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