Hi,
I have built a query from 4 different tables. Simply, I want to maintain the data from the first table and add in data if present from the other 3 tables.
My first table has all employee numbers, I am using that to link to the other 3 tables. My issue is not every employee shows in the other 3 tables. I believe that is causing my query to drop that employee. Is there a way to fix this? I would like my query to still show every employee and just provide a 0 or no value if they are not present in one of the tables.
I have built a query from 4 different tables. Simply, I want to maintain the data from the first table and add in data if present from the other 3 tables.
My first table has all employee numbers, I am using that to link to the other 3 tables. My issue is not every employee shows in the other 3 tables. I believe that is causing my query to drop that employee. Is there a way to fix this? I would like my query to still show every employee and just provide a 0 or no value if they are not present in one of the tables.