> I want a list of table1.id not included in Table2 but i don't find the > solution!
I _*think*_ this will work for you. If I'm wrong, I'm sure someone will come behind and correct me: select table1.id from table1 left outer join table2 on table1.id = table2.id where table2.id = NULL; Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]