I have two tables.
1st table:
called kimlik
id ad
---------------
1 ahmet
2 mehmet
3 ali
2nd table:
called siparis
id kimlikid tarih miktar
------------------------------------------------------------
1 1 22.09.2011 10
1 2 22.09.2011 100
I want to list via SQL query to persons who doesn't give an order on 22.09.2011.
Result:
ad tarih
--------------------------
ali 22.09.2011