Thanks to all those who have responded! This is the sql query I am looking for. It's good to have such a user mail list.
---- SELECT Table1.ID FROM Table1 LEFT JOIN Table2 Using(ID) WHERE Table2.ID IS NULL when you do a left join, if there is no cooresponding row in the second table, then a row of NULL's are effectively joined to the left row, so picking the rows where the Table2.ID IS NULL will work, provided that NULL is not a valid value for the ID field. regards, sean peters [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php