troubleshooting Question

help with an sql join query?

Avatar of ipjyo
ipjyoFlag for United States of America asked on
DatabasesMicrosoft AccessSQL
10 Comments6 Solutions227 ViewsLast Modified:
Hi,

I have two tables in my access database as follows.
I am trying to get the records those exist in tblMap2 for TranID = "Borrower" and does not exist in tblMap1. In the below tables I need to get the records d3 and d4 for TranID = "Borrower" because these records does not exist in tblMap1 where TranID = "Borr".

Can anybody please help me how to write this query?
Thanks.
tblMap1

TranID     FieldName
------     ---------
Borr       d1
Borr       d2
Grntr  	   d1
Grntr      d2
Grntr      d3
Cos        d1
Cos        d2
Cos        d3


tblMap2

TranID     FieldName
------     ---------
Borrower   d1
Borrower   d2
Borrower   d3
Borrower   d4
Guarantor  d1
Guarantor  d2
Guarantor  d3
Cosigner   d1
Cosigner   d2
Cosigner   d3
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 6 Answers and 10 Comments.
Join the Community
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 6 Answers and 10 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