I apologize in advance if this question has been answered before. I am an newbie to MS Access and Queries, I have been stuck on this for a couple of days and need help.



If I have two Tables with the following fields

TableA 8000 records

DocID
Field2
Field3
Field4
......

TableB 200 records

DocID
Field2
Field3
......

What I am trying to accomplish is to take the DOCIDs from TableB and find the matching DOCIDs in TableA. Once found, I would like the query to show all of the data from TableA "DOCID, Field2, Field3, Field4 ......" I have been trying to do this with a Right Join in my query with no success.

Thanks in advance