Re: sql question

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 : Steven(dot)Verhoeven(at)dmbr(dot)UGent(dot)be
> URL : http://www.dmbr.UGent.be
>
>
>