Comparing two tables 1

[matpj]

I have a table with a load of fields - one being 'Project ID'.

another table I have is a project tabe, also containing 'Project ID'

I want to be able to write a query that tells me which Project ID's in table 1 are NOT in table 2.

how can this be achieve????

 

[lespaul]

One solution:

SELECT * FROM TABLE1 WHERE PROJECTID NOT IN (SELECT PROJECTID FROM TABLE2)



Leslie

 

[matpj]

hmmm, why didn't I think of that....

 

[lespaul]

probably that forest ~ tree thing!

thanks for the star

les