Steven Verhoeven 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 ? Who can help me ?
How about select id, mref AS ref from table UNION select id, fref AS ref from table
Or is that not what you want?
Best Wishes, Chris Travers Metatron Technology Consulting
--
/A computer is like an airconditioner. When windows open, it stops working ! /
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Steven Verhoeven, ICT Support Engineer
Department for Molecular Biomedical Research (DMBR) VIB - Ghent University 'Fiers-Schell-Van Montagu' building Technologiepark 927B - 9052 Ghent (Zwijnaarde) Belgium Tel : +32-(0)9-33-13.606 Fax : +32-(0)9-33-13.609 E-mail : [EMAIL PROTECTED] URL : http://www.dmbr.UGent.be
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
