This should be simple but I am stuck here. I need to select rows from table 1, which do not have matching ID in table 2. Say each table has 100 rows each, and 90 rows from table 1 have matching 90 rows in table 2. SO I want to find remaining 10 rows. Simple query such as
select tbl1.id from tbl1, tbl2 where tbl1..id = tbl2.another_id; returns me the matching 90 rows, but my job is now to find out remaining 10 rows, how do I do it. I have done this before but can't recall it now, simply replacing "=" with "<>" naturally returns Cartesian product. Any help will be highly appreciated. TIA, - Manish -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
