How to tell it in MySQL
I have 2 tables and i want to find difference (the id exists in one
table but in the other not) between them.
With SELECT attachment_id from tbl_attachment, tbl_msg2atta where
attachment_id = atta_id
i receive all id wich are equals in both tables.
I need to know
On Wed, 1 Oct 2003 10:56:59 +0200
Stefan Berger [EMAIL PROTECTED] wrote:
I have 2 tables and i want to find difference (the id exists in one
table but in the other not) between them.
With SELECT attachment_id from tbl_attachment, tbl_msg2atta where
attachment_id = atta_id
i receive
Stefan Berger escribió:
How to tell it in MySQL
I have 2 tables and i want to find difference (the id exists in one
table but in the other not) between them.
With SELECT attachment_id from tbl_attachment, tbl_msg2atta where
attachment_id = atta_id
i receive all id wich are equals in both
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: