Hi there,
I have another group by problem. I have two tables which can be represented as ;
Table 1:
Col1, Col2, Col3
ID1, Test1, 0.3
ID1, Test2, 0.2
ID1, Test3, 1.0
Table2:
Col1, Col2, Col3
ID1, Test1, 0.3
ID1,Test3, 1.0
How can Iidentify and return back the missing value from table2, that is found in table 1 i.e. ID1, Test2, 0.2 , as the other rows are found in both tables.
Thanks,
Stanage.