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