> select table1.id from table1 left outer join table2 on table1.id = table2.id > where table2.id = NULL;
Sorry, that last should be where table2.id IS NULL; Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]