Hi,

Does anyone know in MySQL, how to exclude one set of record from another set, which is similar to 'NOT IN' in some SQL language.
e.g: select * from A where A.ID NOT IN ( select ID from Table B )

Thanks a lot.

Roger

Join and look for NULL should do it ...

select * from A left join B on A.id = B.id where B.id is NULL;

(See "Checking for values not present in a table" in MySQL by Paul DuBois, http://www.wellho.net/book/0-7357-0921-1.html

Cool!
It works!
Thanks, Graham!

---