query the different row between two tables

[scorpioy]

This might be a newbie question. Hope that someone could help me.

I have two tables, one table has id and telephone; the other has id and address. id in both table have the same values and it is the unique key. Now one table has one more row than the other (and in the rest rows, id value in both tables are the same), what query should I write in order to retrieve that extra row out?

Thanks

[tsinka]

Hi,

the following query fetches all ids from table a that don't have matchings rows in table b:

SELECT a.id FROM tablea a LEFT JOIN tableb b
ON a.id=b.id
WHERE b.id IS NULL

Thomas

[scorpioy]

thanks, it works