i would like some help from some experts in SQL im using microsoft access to get an external report, i have 2 tables which is named "Person Table" and "Badge Table" now on the person table there are 3 columns that i want to get which is first name, last name and employee number. on the badge table i want to get the encoded number. when i try to create a report either it wouldnt generate any data or the data is not synchronized, meaning the encoded number is not for the intended person.