Thread: i am a fool

i am a fool

From
Hassanuri Bin Shah
Date:
hello
i don't know whether to ask here or the psql-sql but here goes...
how do i make a crosstab query from say:

job_no | year_month | input |
------------------
716        20004                100
717        20005                120
716        20006                130


to

job_no |  20004 | 20005 | 20006
-------------------
716        100                        130
717                          120


thank you.. in advance.

[x]



Attachment