Hi, we have 2 tables For each record in Table1 there are 2 records in Table2.
Table1 (T1) == 1 2 Table2 (T2) T2 T1 ====== 1 1 2 1 3 2 4 2 What is the cheapest way to get a dataset like below? T1 T2a T2b =========== 1 1 2 2 3 4 Thank you very much for your help. Josef Gschwendtner
