compare tables (complement ...)
This is probably a stupid question and an easy task. But I do not get a grip to the following problem:
I have two lists of numbers, lets say:
I want to import those lists into a table each and than identify the entries, that both have in common (3,4) and a list of entries reduced by the "common" entries (List-1-reduced: 1,2,5,6 and List-2-reduced:7).
Can anybody help me? I assume it will be a "join" mechanism, but I do not manage to design it properly.