coba ni : select iif(kolom1='a',kolom2) as a, iif(kolom1='b',kolom2) as b from table1
NB : sori belum dicobain
Salam
Awin
PALUARED <[EMAIL PROTECTED]> wrote:
Dear all,
saya punya tabel1 isinya
kolom1 kolom 2
a 23
a 34
a 76
b 54
b 12
b 90
ingin hasilnya
a b
23 54
34 12
76 90
kira2 querynya gimana ya?
TIA
---------------------------------
Looking for last minute shopping deals? Find them fast with Yahoo! Search.
