Queries with Overlapping Data

[ineedaccesshelp]

I have 2 DBs of QBs and RBs information which have overlapping fields of information such as Name, Position, ect but some non-overlapping fields such as Rush TDs and Pass TDs. How do I create a query that consolidates the overlapping fields but includes the fields that don't overlap?

[JoeM]

Create a query linking the two tables together (I am guessing based on team and player name), then select to return the fields you want to see.