Re: A and C not B

----- Original Message -----

From: Reshat Sabiq

To: Chad Thompson

Sent: Wednesday, September 11, 2002 4:45 PM

Subject: Re: [NOVICE] A and C not B

select * from x where y in('A', 'B');

 

 

Thats not quite what i want.  Finding A and B are easy as they are in the table.  Finding C is easy because it is not.  But if i want one list of B and C, thats a little harder.  Meaning B which is listed in the table as type B, and C which is not in the table at all.

 

I believe I will need something like

select * from lists l, tiers t

where l.number = t.number

and t.tier = B

or t.tier <> A

 

This example obviously doesnt work but maybe it gives a better explanation of what i am looking for.

 

Thanks

Chad