Hi Moishe,
The following query will solve your provlem.
Select a.* from a left join b on a.c = b.c where b.c is null;
Anvar.
At 09:53 PM 01/11/2001 -0800, you wrote:
>Perhaps this is more of a general SQL question than a MySQL specific one,
>and I may be exposing my ignorance by asking this, b
Perhaps this is more of a general SQL question than a MySQL specific one,
and I may be exposing my ignorance by asking this, but I figure it's worth a
shot.
I have two tables, 'a' and 'b'. Each contains a value 'c'. I want to
select all 'a' rows where a.c is not in the set of b.c. Is this poss
