OOPs.
I mean
SELECT t1.id
, t1.fref
FROM t1
UNION ALL
SELECT t1.id
, t1.mref
FROM t1
----- Original Message -----
Sent: Sunday, March 13, 2005 6:34
PM
Subject: Re: [NOVICE] [GENERAL] sql
question
SELECT t1.id
, t1.fref
FROM t1
UNION ALL
SELECT t2.id
, t2.mref
FROM t2
----- Original Message -----
Sent: Friday, March 11, 2005 4:36
AM
Subject: [GENERAL] sql question
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 ?
-- 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 |
|
|