Need a query to get the difference of two tables

[Harish]

Hi,

I apprecaite anybody replying me with an equvalent query for this:
I am using mysql 4.0.21


select a.address from a where a.id not in (select b.iid from b where
b.message='y')

- Harish


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