I have 2 queries I am trying to combine here.
I have 2 tables.
Basically:
Table1:
Date
EmployeeCode
Hours_On_TA_System
Table2:
Date
EmployeeCode
Hours_On_WMS_System
I'm trying to combine the two so that I get a list of:
Date
Employee Code
Hours_On_WMS
Hours_On_TA
The problem with doing a join is that employees may appear in either table1, table2 or both.
With joins I can either show those in table1 matching to those in table 2. Or those in table 2 and the matching records from table 1.
There may be people who are in table 1 and not table 2 but also those that are in table 2 but not 1 at the same time.
Any ideas...I seem to remember something about Union queries but I can't see if this is what I need.
Cheers
Sockpuppet
I have 2 tables.
Basically:
Table1:
Date
EmployeeCode
Hours_On_TA_System
Table2:
Date
EmployeeCode
Hours_On_WMS_System
I'm trying to combine the two so that I get a list of:
Date
Employee Code
Hours_On_WMS
Hours_On_TA
The problem with doing a join is that employees may appear in either table1, table2 or both.
With joins I can either show those in table1 matching to those in table 2. Or those in table 2 and the matching records from table 1.
There may be people who are in table 1 and not table 2 but also those that are in table 2 but not 1 at the same time.
Any ideas...I seem to remember something about Union queries but I can't see if this is what I need.
Cheers
Sockpuppet
Comment