Query getListPegawaiDinasPendidikanAtasan

mail@pastecode.io avatar
unknown
mysql
2 months ago
434 B
1
Indexable
Never
SELECT 
	ri.id AS instansi_id, 
	ri.nama AS instansi_nama, 
	u.id AS unor_id, 
	u.unit AS unor_unit, 
	p.jabatan_siasn, 
	p.jabatan, 
	p.nip, 
	p.nama AS pegawai_nama,
	p.id AS pegawai_id
FROM pegawai p 
LEFT JOIN unor u ON u.id = p.unor_id 
LEFT JOIN ref_instansi ri ON ri.id = p.ref_instansi_id
WHERE p.jenis_jabatan  = '1' 
	AND u.unit LIKE 'DINAS PENDIDIKAN%' 
	AND u.deleted_at IS NULL
	AND p.disabled_at IS NULL;
Leave a Comment