troubleshooting Question

How can I create a query comparing multiple fields across 2 tables?

Avatar of future_hooves
future_hooves asked on
Microsoft AccessSQL
3 Comments2 Solutions279 ViewsLast Modified:
Hello Experts,
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?


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros