Following on from Andrew Bickerton's answer...
The 4th way is to use EXCEPTEXCEPT
(aka MINUS
) where the RDBMS supports it
.
This should give the same execution plan as NOT EXISTSNOT EXISTS
DECLARE @NoDateWanted date = '20110922';
SELECT id, @NoDateWanted AS tarih
FROM kimlik
EXCEPT
SELECT id, @NoDateWanted
FROM siparis
WHERE tarih = @NoDateWanted;
Edit: Now with added corrections.
You'll have to add the date filter in as a constant.
When you check for "no rows" there is no row to pull the data from of course.