Rabu, 03 Oktober 2012

MySQL - Delete table menggunakan inner join


DELETE a
from t_gaji as a inner join t_pegawai as b on a.nik=b.nik
WHERE a.periode='201206' and b.departemen='OUTSOURCING' and b.penempatan_kerja='BALARAJA';

Tidak ada komentar: