help me
| From: | Hassanuri Bin Shah | Date: | Mon, 06 Nov 2000 15:16:56 +0000 |
| Subject: | help me | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-4248@lists.php.net to get a copy of this message | ||
hello
how do i make a crosstab query from say:
table:
job_no | year_month | input |
-----------------------------
716 | 20004 | 100 |
717 | 20005 | 120 |
716 | 20006 | 130 |
to
query result:
job_no | 20004 | 20005 | 20006
------------------------------
716 | 100 | | 130
717 | | 120 |
thank you.. in advance.
[x]
--
--------------------------------------
| Hassanuri Bin Shah Mohd Amin |
| uhassan@pc.jaring.my |
| http://pwp.maxis.net.my/hassanuri |
| [x]Satan, [x] |
--------------------------------------