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
|
- Re: [GENERAL] sql question Steven Verhoeven
- Re: [GENERAL] sql question Vincent Hikida
- Re: [NOVICE] [GENERAL] sql question Vincent Hikida
- Re: [GENERAL] sql question Russell Smith
- Re: [GENERAL] sql question Klint Gore
- Re: [GENERAL] sql question Chris Travers
- [GENERAL] sql question Steven Verhoeven
- Re: [GENERAL] sql question George Essig
- Re: [GENERAL] sql question Ragnar Hafstaš
- [GENERAL] SQL Question Alex
- Re: [GENERAL] SQL Question Thomas Kellerer