SELECT wo, ht_code AS wo_code
FROM VTempWO
UNION ALL
SELECT wo, emi_code AS wo_code
FROM VTempWO AS VTempWO_2
UNION ALL
SELECT wo, ho_code AS wo_code
FROM VTempWO AS VTempWO_1
Computer Programmer - TenarisSPIJ
Riyan Sugara
Computer Programmer - Email : [email protected]
Phone : +62-254 - 931 - 54 - 52
_____
From: [email protected] [mailto:[email protected]]
On Behalf Of Riyan Sugara
Sent: Tuesday, June 02, 2009 10:44
To: [email protected]
Subject: [belajar-access] Bagaimana SELECT kolom jadi baris
Rekan2 & suhu Access,
Saya punya table seperti ini :
Wo ht_code emi_code ho_code
================================
04119 2 3 4
Ingin di SELECT menjadi :
Wo WO_code
===============
04119 2
04119 3
04119 4
Select nya gimana ya?
Computer Programmer - TenarisSPIJ
Riyan Sugara
Computer Programmer - Email : [email protected]. <mailto:riyan%40spij.co.id> id
Phone : +62-254 - 931 - 54 - 52
