Two tables with similar data, query

j1s15n
04:25:17
I have two tables that have a column labeled Name:
[CurrentRecords].[Name]
[tbl_vPC].[Name]

However, the CurrentRecords table has more info on each name such as jr, sr, II, III, etc, but the tbl_vPC does not contain that extra information.
Example:
CurrentRecords has: ROBINSON, ROBERT E JR
tbl_vPC has: ROBINSON, ROBERT E
CurrentRecords has: ALLEN, DUG V III
tbl_vPC has: ALLEN, DUG V

Is there a query where I can find all records in the CurrentRecords and all records in tbl_vPC that are similar?
subhendu
07-30-2017
Try Left Join
You need to join by name
Please Login to post your reply or start a new topic