Regarding SQL Server joins

[mendhak]

SELECT field1,field2,field3 FROM Table1 WHERE NOT EXISTS
(SELECT id FROM Table2 WHERE Table2.id = Table1.id)