On Fri, 11 Mar 2005 13:36:17 +0100, Steven Verhoeven <[EMAIL PROTECTED]> wrote: > Hi all > > My table definition : > > id | fref | mref > ------+-----------+---------- > 1 | 23 | 25 > 2 | 24 | 28 > 3 | 25 | 31 > 4 | 26 | 34 > > My problem : > 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 ?
select id, fref from mytable union all select id, mref from mytable order by 1,2 klint. +---------------------------------------+-----------------+ : Klint Gore : "Non rhyming : : EMail : [EMAIL PROTECTED] : slang - the : : Snail : A.B.R.I. : possibilities : : Mail University of New England : are useless" : : Armidale NSW 2351 Australia : L.J.J. : : Fax : +61 2 6772 5376 : : +---------------------------------------+-----------------+ ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings