Membuka objek dok yg dipakai berkas lain

--select * from regprosedur
--where berkasprosedurid =
--(select berkasprosedurid from berkasprosedur
--where berkasid =
--(select berkasid from berkas where berkasnomor = 2299 and berkasyear = 2007));


select berkasid from berkas where berkasnomor = 2394 and berkasyear = 2007;

select * from berkasprosedur
where berkasid ='fc3e4963ae294fe7b4f7de8770b4b9d5';

select * from regprosedur
where berkasprosedurid ='f7e5fb1c0f0944749f69574658bc6217';

--select * from register
--where regdocdate = '02/12/2007';

--select * from register
--where regid = '4d2462edf6124249976a7d3e4967fad2';