I have a table with just a column listing 5606 item#s. Each of them occur just once. I want to run a query to find all of the occurrences of those 5606 in another table where those item#s occur multiple times each, so I can then run a delete query to delete all of those occurrences. I can't seem to figure out how to run an unmatched-style query to do this.
So it's basically:
TableA - TableB -
ItemNum joins ItemNum
Records in Table A are something like:
ItemNum
100101
102
103
Records in Table B are something like:
ItemNum
100
100
100
100101
101
101
101
102
102
102
103
103
103
103
103