Halo all
Saya punya table seperti ini

Item      JAN    FEB    MAR     APR     MAY     JUN     JUL     AUG
SEP     OCT     NOV   DES

Mangga   1    4    8     3     2     9     4     8     3     8     1
9
Jeruk    3    7    0     6     2     9     2     7     1     8     4
2

Jika ingin mengambil Jumlah Item Mangga di bulan SEP syntax nya :

Select SEP from Table_x where item="Mangga'

Utk Bulan Jan   := Select JAN from Table_x where item='Mangga';

Permasalahannya :
Saya Ingin mengambil data Item "Mangga" dengan Kolom bulan sebagai
parameternya, bagaimana caranya ya?

Ada yang bisa memberi masukan tidak?

Thx....


------------------------ Yahoo! Groups Sponsor --------------------~--> 
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/PhFolB/TM
--------------------------------------------------------------------~-> 

--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------

Bergabung dengan Indonesia Thin Client User Groups, 
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/indo-oracle/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 



Kirim email ke