Thread: Rows to columns query

Does anyone know if this is feasable

I have two tables

one has inv_id,amount,date, cheque no

the second has
inv_id, amount , code (this relate to type of expenditure)

There is a one to many relationship on inv_id

What I want to do is

Group all the fields in the first table (easy), but then have the
grouped values in the 2nd table appearing as values in the columns ie

inv_id, cheque, amount_vote1,amount_vote2,amount_vote3 etc

Is this doable/feasable (preferably in a view)

On Mon, 10 May 2004, mike wrote:

> Does anyone know if this is feasable
>
> I have two tables
>
> one has inv_id,amount,date, cheque no
>
> the second has
> inv_id, amount , code (this relate to type of expenditure)
>
> There is a one to many relationship on inv_id
>
> What I want to do is
>
> Group all the fields in the first table (easy), but then have the
> grouped values in the 2nd table appearing as values in the columns ie
>
> inv_id, cheque, amount_vote1,amount_vote2,amount_vote3 etc
>

See contrib/tablefunc's crosstab functions.  You will need to know the
number of output columns in advance though.

Kris Jurka