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]


begin:vcard 
n:Shah Mohd Amin;Hassanuri
x-mozilla-html:FALSE
url:pwp.maxis.net.my/hassanuri
org:;Accounts
adr:;;;;;;
version:2.1
email;internet:[EMAIL PROTECTED]
title:MIS
x-mozilla-cpt:;0
fn:Hassanuri Shah Mohd Amin
end:vcard

Reply via email to