coba perintah ini.
SELECT [nama], IIF([kode]=1,"HADIR","ABSEN") AS [Absensi] FROM [DATAABSENSI] ket : [nama] Field yg berisi A, B...E [kode] feld yg berisi 1 atau 0 [Absensi] Field temporary atau buatan para Suhu mohon CMIWW ----- Original Message ----- From: bl4ckpitbull To: [email protected] Sent: Wednesday, May 02, 2007 8:05 PM Subject: [indoprog-vb] Tanya sql query Salam programmer. Saya ada pertanyaan. mohon bantuannya. terima kasih sebelumnya. ada data di database (sql) : select * from dataAbsensi hasilnya : A 1 B 0 C 1 D 1 E 0 yang saya mau hasilnya langsung ditampilkan A HADIR B ABSEN C HADIR D HADIR E ABSEN query nya gimana ya? Thanx sekali lagi. - Rudy - [Non-text portions of this message have been removed]
