SQL boking 208 HT dipercepat

208 HT dipercepat

update expr set exprdatstart="26/12/2005"
where expeid=(select expeid from expe
where expecod=4 and expeyea=2006);

select exprdatstart from expr exprdatstart=tanggal mulai kegiatan
where expeid=(select expeid from expe
where expecod=4 and expeyea=2006);


update expr set exprdatstart="26/12/2005"
where expeid in (select expeid from expe
where expecod in (1,2,3,4) and expeyea=2006);

select exprdatstart from expr
where expeid in (select expeid from expe
where expecod in (1,2,3,4) and expeyea=2006);