revisi query ke 2, kurang end nya..8D select No_Kendaraan, case when tgl_ijin3 is not null then tgl_ijin3 else (case when tgl_ijin2 is not null then tgl_ijin2 else tgl_ijin1 end) end as Tgl_Ijin from T_Table
------------------------ Yahoo! Groups Sponsor --------------------~--> Educate a girl. Change her future. Give her hope. http://us.click.yahoo.com/EQN7IB/UREMAA/HwKMAA/x3XolB/TM --------------------------------------------------------------------~-> ================> HAPUS IKLAN DIATAS DAN FOOTER INI JIKA ME-REPLY <================ Posting : [email protected] Archive : http://www.mail-archive.com/[email protected]/ www.mitek.unibraw.ac.id || himamitek.brawijaya.ac.id ************************************************************************************ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/mitek/ <*> 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/
