update com_master_pegawai a,com_master_pegawai_inpas b SET a.kelas_jabatan=b.KELAS,a.jabatan=b.JAB_BARU where a.nip=b.NIP_BARU AND a.jenis_jabatan='0';
select a.nip,a.kelas_jabatan,a.jabatan,b.KELAS,b.JAB_BARU from com_master_pegawai a, com_master_pegawai_inpas b where a.nip=b.NIP_BARU AND substr(a.kolok,1,2)='24'order by a.kelas_jabatan ASC
select nip,nama,jabatan,kelas_jabatan from com_master_pegawai where substr(kolok,1,2)='24' AND jenis_jabatan='0' order by kelas_jabatan ASC;
Tidak ada komentar:
Posting Komentar