B
BlueWolvering
I am trying to find every entry on list A that is NOT on list B. So I am
trying to subtract list B out of list A. So far, all I have been able to do
is get rid of the intersection, such that I have every entry not in both.
The code for that is
SELECT A.ID FROM A LEFT JOIN B ON A.ID = B.ID WHERE B.ID IS NULL UNION
SELECT B.ID FROM B LEFT JOIN A ON B.ID = A.ID WHERE A.ID IS NULL;
How do I get rid of the entries in List B?
By the way, a right join in the above code produces an empty set.
I am using Microsoft Access 2003 and do NOT have options to switch versions.
Resources at my disposal are the internet, and The Microsoft Access 2000
Bible by Cary N. Prague and Michael R. Irvin. (Figures right?)
Don't feel obligated to answer in the form of a page reference from that
book, I include it because maybe it helps someone help me. If it's not
useful to your reply, disregard.
Thank you.
trying to subtract list B out of list A. So far, all I have been able to do
is get rid of the intersection, such that I have every entry not in both.
The code for that is
SELECT A.ID FROM A LEFT JOIN B ON A.ID = B.ID WHERE B.ID IS NULL UNION
SELECT B.ID FROM B LEFT JOIN A ON B.ID = A.ID WHERE A.ID IS NULL;
How do I get rid of the entries in List B?
By the way, a right join in the above code produces an empty set.
I am using Microsoft Access 2003 and do NOT have options to switch versions.
Resources at my disposal are the internet, and The Microsoft Access 2000
Bible by Cary N. Prague and Michael R. Irvin. (Figures right?)
Don't feel obligated to answer in the form of a page reference from that
book, I include it because maybe it helps someone help me. If it's not
useful to your reply, disregard.
Thank you.