Ok..... I will do my best to explain this:
I have 2 tables. tblA and tblB.
tblA has 4 fields. item, id1, id2, id3
tblB has 4 fields. color, id1, id2,id3
I need to query both tables with this criteria:
Show all records from tblA and matching records from tblB where tblA.id1, tbl.Aid2, tblA.id3 = tblB.id1, tbl.Bid2, tblB.id3. All three need to match.
Is this possible?