[GENERAL] sql question

[Steven Verhoeven]

My table definition :
  id | fref  | mref
--+---+--
 1   | 23|   25
 2   | 24|   28
 3   | 25|   31
 4   | 26|   34
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 ?
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[GENERAL] sql question

[Steven Verhoeven]

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