I have a question concerning a query I need to create. I am trying to join 3 tables to become one table with the information.
I have two tables with some overlapping data that is employee related with the employee ID as the primary key. I want the end result to be a table with data from both tables that matches overlapping data and appends data that does not overlap.
The employee information in both tables varies, some appears in one and not the other. I want to bring the info from each individual employee into the same column in my table and have their corresponding data associated with them and not duplicate nor overlap.
Can you point me in the direction where I can pull this together? I have created queries and joined two tables but not three and I am not sure which fields I must include from the individual table and where exactly to make the joins to get everything I need.
I would appreciate any help at this point I am so frustrated. I have books but they are not giving me step by step instructions.
