On Wednesday 26 July 2006 10:31 am, Peter Lauri wrote: > Best group member, > > I just made up this query, but let us work from this: > > SELECT * FROM table1 > LEFT OUTER JOIN table2 ON (table1.id=table2.id) > WHERE table2.prop IS NULL;
If I understand correct: SELECT * FROM table 1 WHERE id NOT IN (SELECT id FROM table2); -- Chris White PHP Programmer/DBacardi Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
