Finding rows in table A which do not have a match in table B
From: Dave Hammond <dh1760_at_gmail.com>
Date: 12 Oct 2006 12:06:26 -0700
Message-ID: <1160679986.440022.90670_at_m7g2000cwm.googlegroups.com>
Hi All,
Date: 12 Oct 2006 12:06:26 -0700
Message-ID: <1160679986.440022.90670_at_m7g2000cwm.googlegroups.com>
Hi All,
NAME HOURS DATE
---- ----- ----
JOHN 40 2006-10-12 JANE 40 2006-10-12 FRED 25 2006-09-30
The rows for JOHN and JANE have identical values in the DATE field of
both tables; however, the row for FRED has a different DATE value in each table, so it would appear in the query result:
NAME ID DATE
---- -- ----
FRED 03 2006-09-30
This is probably a newbie SQL question, but I can't find the solution,
so I'm asking the experts. :)
Thanks!
-Dave H.
Received on Thu Oct 12 2006 - 21:06:26 CEST