I have a query based on about 10 different tables. One table 'basic' has about 1250 employees on it, the other tables relate to their benefits and salary information (these other tables only have about 1150 records of data). My final query shows the 1150 records, where are the others from the 'basic' table? I checked the design view of the query and looked at the links, all have ssn as primary key. What should I do to fix this? I want to show ALL data in 'basic' and only those with same primary key in the other tables.
Please Help.
AND GOOD MORNING! :O)
Never mind. I figured this one out as well. Went into the design view of query and clicked on the links to fix the join.
Thanks anyway!!
Please Help.
AND GOOD MORNING! :O)
Never mind. I figured this one out as well. Went into the design view of query and clicked on the links to fix the join.
Thanks anyway!!
Last edited:
