Query DELETE dengan JOIN Postgre

 Contoh select menggunakan join :

select count(a.initial_store) from karyawan_jadwal a
join karyawan b on a.nik = b.nik
where a.initial_store = 'KPT' and b.jobgrade_code = 'THL'

 Contoh select menggunakan Lain menyerupai join (untuk delete) :

select count (initial_store) from karyawan_jadwal
where initial_store = 'KPT'
AND nik in 
(select nik from karyawan where jobgrade_code = 'THL')

Contoh delete dengan join :

delete from karyawan_jadwal
where initial_store = 'KPT'
AND nik in 
(select nik from karyawan where jobgrade_code = 'THL')