This may or may not be a dumb question, but I'm not good with queries. I am trying to create a Select query that will display the records of multiple tables tied to a single userID. However, when I try to create these on my own, I wind up with a bunch of duplicates. For example:
I have 3 tables: tbl_Users, tbl_appAccess, and tbl_adAccess
tbl_Users has the primary record of userID "abc123"
tbl_appAccess has 2 records tied to abc123
tbl_adAccess has 3 records tied to abc124
When I run the query I have setup, the 2 records from tbl_appAccess are duplicated for every record in tbl_adAccess.
abc123 app1 ad1
abc123 app1 ad2
abc123 app1 ad3
abc123 app2 ad1
abc123 app2 ad2
abc123 app2 ad3
My end goal is to have a query that can display like this:
abc123 app1 ad1
abc123 app2 ad2
abc123 ad3