pakai ini aja Select nama, 'R' RL, ukuranR from table union all Select nama, 'L' RL, ukuranL from table
salam Sofyan B -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Tuesday, October 21, 2008 3:08 PM To: [email protected] Subject: [indo-oracle] SQL Merubah Kolom Menjadi Baris Dear All.. Ada yg bisa bantu SQL untuk Merubah Kolom Menjadi Baris Contohnya : Nama UkuranR UkuranL -------- ------------- ------------ Rina 50 60 Menjadi Nama RL Ukuran Rina R 50 Rina L 60 Sebelumnya terimakasih ya atas bantuannya..... [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
