Thanks!!! It works, the only change I needed was - WHERE tbl2..another_id IS NULL
rgds, - Manish ----- Original Message ----- From: "Johan Hook" <[EMAIL PROTECTED]> To: "Manish" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, August 20, 2004 12:32 PM Subject: Re: Select non-matching rows > Hi, > you could try: > > SELECT tbl1.id > FROM tbl1 > LEFT JOIN tbl2 ON tbl2.another_id = tbl1.id > WHERE tbl2.id IS NULL > > /Johan > > Manish wrote: > > > 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 > > > > > > > -- > Johan Höök, Pythagoras Engineering Group > - MailTo:[EMAIL PROTECTED] > - http://www.pythagoras.se > Pythagoras AB, Stormbyv. 2-4, SE-163 55 SPÅNGA, Sweden > Phone: +46 8 760 00 10 Fax: +46 8 761 22 77 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
