wow. yeah it works. Thanks a lot. -N.
-------------------------------------------------------- > On Mon, 01 Sep 2003 17:13:20 +0900 > Nishant <[EMAIL PROTECTED]> wrote: > > > I dont know why my brain stopped working :) > > > > I have two tables T1 and T2, both of which have a column : SerialNo > > > > Now I want to select those rows from T1 whose SerialNo is not present in > > T2. > > > > This dont work: > > > > select T1.* > > from > > table1 as T1 > > straight_join > > table2 as T2 > > where > > T1.serialNo != T2.serialNo > > order by > > T1.serialNo > > > > Looking for some help. > > Look here: > http://www.mysql.com/doc/en/JOIN.html > > *** > If there is no matching record for the right table in the ON or USING part in a LEFT > JOIN, > a row with all columns set to NULL is used for the right table. You can use this > fact to > find records in a table that have no counterpart in another table: > > mysql> SELECT table1.* FROM table1 > -> LEFT JOIN table2 ON table1.id=table2.id > -> WHERE table2.id IS NULL; > *** > > --- > WBR, > Antony Dovgal aka tony2001 > [EMAIL PROTECTED] > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]