Thread: sql question

sql question

From

Steven Verhoeven

Date:

14 March 2005, 05:15:22

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 ?

Re: sql question

From

George Essig

Date:

14 March 2005, 08:13:33

On Fri, 11 Mar 2005 13:26:07 +0100, Steven Verhoeven
<Steven2@dmbr.ugent.be> wrote:
> 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 ?

select id, fref as ref from my_table
union
select id, mref as ref from my_table;

Re: sql question

From

Ragnar Hafstað

Date:

14 March 2005, 11:41:48

On Sun, 2005-03-13 at 23:13 -0600, George Essig wrote:
> On Fri, 11 Mar 2005 13:26:07 +0100, Steven Verhoeven
> <Steven2@dmbr.ugent.be> wrote:

> [snip problem]

> select id, fref as ref from my_table
> union
> select id, mref as ref from my_table;

union ALL

(see other replies)

gnari