Positivethinking
Programmer
Hello everyone, I need to create a query(ies) that allow to display all Subjects and Tubes with all the Analytes, notice that TABLE1 has Analytes1,2,3 and TABLE2 has Analytes4,5. Subj 1A has all 5 Analytes, a Subject could be in table 1 but not in table 2 or viceversa, or could be in both. The desired display is all the way below. Your help is much appreciated. Thanks
TABLE1
MyID Subj Tube Site An1 An2 An3
1A 1 1 A 2 3 4
1A 1 2 A 3 9 0
8A 8 1 A 7 5 6
TABLE2
MyID Subj Tube Site An4 An5
1A 1 1 A 0 5
1A 1 2 A 0 4
2C 2 1 C 4 7
2C 2 2 C 2 9
3D 3 2 D 3 9
5C 5 1 C 1 6
DESIRED DISPLAY
MyID Subj Tube Site An1 An2 An3 An4 An5
1A 1 1 A 2 3 4 0 5
1A 1 2 A 3 9 0 0 4
2C 2 1 C - - - 4 7
2C 2 2 C - - - 2 9
3D 3 2 D - - - 3 9
5C 5 1 C - - - 1 6
8A 8 1 A 7 5 6 - -
TABLE1
MyID Subj Tube Site An1 An2 An3
1A 1 1 A 2 3 4
1A 1 2 A 3 9 0
8A 8 1 A 7 5 6
TABLE2
MyID Subj Tube Site An4 An5
1A 1 1 A 0 5
1A 1 2 A 0 4
2C 2 1 C 4 7
2C 2 2 C 2 9
3D 3 2 D 3 9
5C 5 1 C 1 6
DESIRED DISPLAY
MyID Subj Tube Site An1 An2 An3 An4 An5
1A 1 1 A 2 3 4 0 5
1A 1 2 A 3 9 0 0 4
2C 2 1 C - - - 4 7
2C 2 2 C - - - 2 9
3D 3 2 D - - - 3 9
5C 5 1 C - - - 1 6
8A 8 1 A 7 5 6 - -