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.
Thanks and Best Regards,
N.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
