Forum Discussion
Create Discrepancy Report from Different Tables
I've been working on this project to help point out any potential issue on payroll and I am having a hard time coming up with a solution. I have 3 seperate tables that stores data related to a pe...
thmonte,
What is your expected result based on the above sample data?
I note that there is no matched personID in the first two tables. And you have many-to-many relationship among the three tables, do you create other bridge tables containing unique personID and unique AssignmentID to estabilish relationships among these tables?
Regards,
Lydia