I've got one huge table (table a), and two smaller tables (tables b and c)
I need to find which records in 'table a' are not in 'table b' nor are they in 'table c'.
The Primary Key for all 3 tables is 'ProductID'.
I looked at the LEFT JOIN command in the docs, but it looks like you can only compare 1 table to 1 table.
How do I do this? -Jeff Gannaway
_______________________________________________
http://RadioU.com This Is Where Music Is Going - Listen Online! _______________________________________________
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]