SQL Percepat Pengumuman 82

select * from doex
where expeid=(select expeid from expe
where expecod=1836 and expeyea=2006);

1. Cek kode dokumen (pengumuman) untuk yg akan dirubah tanggalnya.

update doex set doexdat="18/01/2006"
where expeid=(select expeid from expe
where expecod=1836 and expeyea=2006)
and docuid="cek di tabel docu";