I have query like:
UPDATE nilai_mhs
SET status_nilai = 3
where
id_kode_mk =
(SELECT e.id_kode_mk
FROM nilai_mhs c, tbl_mhs d,master_mk e,tbl_mk_pertahun f
WHERE
c.nim = d.nim
AND
c.id_kode_mk = e.id_kode_mk
AND
e.id_kode_mk = f.id_kode_mk
AND
c.nim = '20081001010125'
AND
c.status_nilai =2
AND
sem_ganjil_genap = 'ganjil')
but the result displays error:
You can't specify target table 'nilai_mhs' for update in FROM clause
Can anybody help me?