G
Guest
There is a union operator to find items in either of 2 sets. Is there a way
to find items that are in both sets and another to find items in one set but
not in the other?
A union B contains all rows from A plus all rows from B (with no duplicates)
A intersect B would contain only rows that are in both tables A and B
A except B would contain only rows that are in A but not in B
to find items that are in both sets and another to find items in one set but
not in the other?
A union B contains all rows from A plus all rows from B (with no duplicates)
A intersect B would contain only rows that are in both tables A and B
A except B would contain only rows that are in A but not in B