Forum Discussion

thmonte's avatar
thmonte
Helper IV
8 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

thmonte's avatar
thmonte
Helper IV
8 years ago

Anonymous I do have a few other tables to create relationships

 

One table of unique personID

One table of unique Date

 

I do not have a table of unique AssignmentIDs but I suppose I can make one?

 

With that being said,  the sample data was real data stripped of sensitive information.  I did not create it with the intent of it actually producing results.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    thmonte,

    Could you please share expected result based on the above sample data you post?

    Regards,
    Lydia