Fwd: how to have 2 select creteria on one column? SOLVED

From: Michael Hoeller <MichaelHoeller(at)t-online(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: Fwd: how to have 2 select creteria on one column? SOLVED
Date: 2005-09-10 16:41:17
Message-ID: 200509101841.17950.MichaelHoeller@t-online.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

sometime you have to write a mail and your brain gets cleared...

select a.code
from stamm a
where
a.skart in (
(select skart
from stamm
where code like '%k%')
)
and a.code not like '%V%';

May be this is not nice but this brings back the list I have.

Michael

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Hoeller 2005-09-10 16:47:48 how to update with a join?
Previous Message Richard Huxton 2005-09-10 16:31:36 Re: how to have 2 select creteria on one column?