I have: select name from a, b where a.type='X' and a.id=b.id;
I want a query to return all the rows that were NOT found by the above query.
I can't simply do:
select name from a, b where a.type!='X' and a.id=b.id;
because there is more than one row in b for each type!='X' but there is only one row in b for each type='X'
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]