Re: sql question
От | Vincent Hikida |
---|---|
Тема | Re: sql question |
Дата | |
Msg-id | 003101c5283e$6bb20780$6501a8c0@HOMEOFFICE обсуждение исходный текст |
Ответ на | sql question (Steven Verhoeven <Steven.Verhoeven@dmbr.UGent.be>) |
Список | pgsql-general |
SELECT t1.id
, t1.fref
FROM t1
UNION ALL
SELECT t2.id
, t2.mref
FROM t2
----- Original Message -----From: Steven VerhoevenSent: Friday, March 11, 2005 4:36 AMSubject: [GENERAL] sql questionHi 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 ?--
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)
BelgiumTel : +32-(0)9-33-13.606
Fax : +32-(0)9-33-13.609E-mail : Steven.Verhoeven@dmbr.UGent.be
URL : http://www.dmbr.UGent.be
В списке pgsql-general по дате отправления: