| Subject: | Query to obtain (A AND (NOT B))? |
| Date: | Sat, 16 Jan 2010 17:35:50 -0800 |
Suppose I have two tables (A and B) with identical structures. I want
to obtain the recordset containing all records that ARE in A and are
NOT in B.
A = {1 2 3 4 5 6 7 8 9 10}
B = {2 4 6 8 10}
then
A & \B = {1 3 5 7 9}
Right?
Is this not a basic SQL query?
Is the syntax "A-B" or "A\B"?