Re: Select statement to get the difference

[Lourdes Millán]

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 tables.
I need to know which id is not present in the other table.   

In some other database i can use something like not exists but here in
Mysql i have troubles to deal it.
Thanks for hints.

Regards



 

Try this:

SELECT attachment_id from tbl_attachment Left Join tbl_msg2atta On 
tbl_attachment.attachment_id = tbl_msg2atta.atta_id
where IsNull(tbl_msg2atta.atta_id)

Lourdes
--
Sus tiendas favoritas, útiles herramientas de compra y grandes ideas 
para regalos. ¡Compre en línea cómodamente con [EMAIL PROTECTED] 
http://shopnow.netscape.com/



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