I have a Microsoft access query I'm trying to set up but have hit a snag since I don't do a lot of raw sql these days. I have two tables (A & B), table B has one field that I need to compare against three fields in table A. I want to find the matches.

The basic format I'm looking at is in this screenshot.

From table B, I want to match the "UPC" field to the "OLD UPC 2" field in table A - matching for the value "2ABCD". But I don't know which field, if any it matches to. Ideally I want to do this in one query. Thoughts?

TABLE A (old data)

TABLE B (new data)