Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select o.nama, o.tgl_lhr, o.agama_id from orang o inner join pns p
- on p.id = o.id
- inner join satuan_kerja sk on sk.id = p.satuan_kerja_kerja_id
- where p.instansi_kerja_id = 'A5EB03E23B00F6A0E040640A040252AD'
- and extract(year from p.tmt_cpns) = '2014'
- and o.jenis_kelamin = 'F' and sk.kanreg_id = '00'
- order by o.nama, o.tgl_lhr;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement