E
Ed
I have two files both linked to a higher table by the same idx
How do I get a combined table with unique attributes of each of the two
files; with some (simple?) query or elegant SQL?
eg T1 and T2 both refer to the same record in T0
T1 and T2 should combine to give T3 (noew, also related to the same record
in T0)
T1from T1to T1val T2from T2to T2val T3from T3to T3valone
T3val2
1 2 x 1 3 p 1
2 x p
4 5 y 3 6 q 2
3 - p
3
4 - -
4
5 y -
5 6 - q
hope that's understandable!
many thanks
How do I get a combined table with unique attributes of each of the two
files; with some (simple?) query or elegant SQL?
eg T1 and T2 both refer to the same record in T0
T1 and T2 should combine to give T3 (noew, also related to the same record
in T0)
T1from T1to T1val T2from T2to T2val T3from T3to T3valone
T3val2
1 2 x 1 3 p 1
2 x p
4 5 y 3 6 q 2
3 - p
3
4 - -
4
5 y -
5 6 - q
hope that's understandable!
many thanks