My table definition :

  id | fref      | mref
------+-----------+----------
 1   |     23    |   25
 2   |     24    |   28
 3   |     25    |   31
 4   |     26    |   34


i need a query that results in this :

id | ref
------+----------
1 | 23 1 | 25
2 | 24
2 | 28
3 | 25 3 | 31
4 | 26 4 | 34



Do I need a crosstab-query ? Who can help me ?


---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to