----- Original Message -----
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.