| 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? |
| smo1234 07-30-2017 | Try Left Join You need to join by name |