Re: Select statement to get the difference

[Randy Chrismon]

>I need to know which id is not present in the other table.

Stefan:
A left join should do it:
select t1.id from t1 left join t2 on t1.id=t2.id where t2.id is null

I learned this from this mailing list about two weeks ago.

HTH.

Randy

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]