I have two tables that have a column labeled 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.
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?
|Try Left Join |
You need to join by name