Return to Revisions

Following on from Andrew Bickerton's answer...

The 4th way is to use EXCEPT where the RDBMS supports it
This should give the same execution plan as NOT EXISTS

SELECT id, ad
FROM kimlik
EXCEPT
SELECT id, 'dummy'
FROM siparis