update desa utk gu & persil lokasi

--select * from reggu
--where regid ='' and gunomor='' and gutahun='';

update reggu set desaid='desaid' -- update kelurahan untuk GU
where regid='regid terkait';

--select

update persillokasi set desaid='desaid' -- update kelurahan untuk STP
where persillokasiid='regid terkait';

select * from berkas where berkasnomor=7359 and berkasyear=2007;

select * from berkasprosedur where berkasid='d6d2a4a6afeb412c98f86a7bed41ca63';

select * from regprosedur where berkasprosedurid='98c2cd0921d04cedb76864599eb5924f';

select * from register where regid in ('145402ce202940b3b65001e724b304d8','995b7cdc8e4f4a83904eb7e144163ced','aae31c350c394b98af348f946eaa2eb0');

select * from supersil where regsuid='145402ce202940b3b65001e724b304d8';

select * from persillokasi where berkasprosedurid='98c2cd0921d04cedb76864599eb5924f';

select * from persil where regid='342020b16df24f628955e1998927459d';

select * from desa where desanama like 'Sunter Jaya%';

select * from persillokasi where desaid='230B32B5CE5A4A5AE040A8C003001C9F'and persilluas=96;


commit;

select distinct a.prosedurcode, a.prosedurdesc
from prosedur a, berkasprosedur
where a.prosedurcode=berkasprosedur.prosedurcode
and exists (select 1 from persillokasi where persillokasi.berkasprosedurid = berkasprosedur.berkasprosedurid);