SQL BT atas nama Badan Hukum Imron

HAK YG SUNYA MASIH GS/SU LAMA

select
keca.kecanam,
desa.desanam,
htan.desaco8,
htan.thakcod,
thak.thakdes,
htan.htanseq,
htan.htanboodat,
htan.htanflgact,
gssuold.gssuare,
shak.shaknam
from inde,htan,gsht,gssuold,desa,keca,
thak,shak,shakinde
where inde.masterpk3 is not null
and htan.desaco8=inde.masterpk1
and htan.thakcod=inde.masterpk2
and htan.htanseq=inde.masterpk3
and desa.desaco8=htan.desaco8
and desa.kecacod=keca.kecacod
and thak.thakcod=htan.thakcod
and gsht.desaco8=htan.desaco8
and gsht.thakcod=htan.thakcod
and gsht.htanseq=htan.htanseq
and gssuold.desaco8=gsht.desaco8
and gssuold.gssuyea=gsht.gssuyea
and gssuold.gssunum=gsht.gssunum
and shakinde.indecod=inde.indecod
and shak.tsubcod="04"
and shak.shakcod=shakinde.shakcod;
---------------------------------------------

HAK YG SUNYA MASIH GS/SU BARU

select
keca.kecanam,
desa.desanam,
htan.desaco8,
htan.thakcod,
thak.thakdes,
htan.htanseq,
htan.htanboodat,
htan.htanflgact,
gssu.gssuare,
shak.shaknam
from inde,htan,paht,gssu,desa,keca,
thak,shak,shakinde
where inde.masterpk3 is not null
and htan.desaco8=inde.masterpk1
and htan.thakcod=inde.masterpk2
and htan.htanseq=inde.masterpk3
and desa.desaco8=htan.desaco8
and desa.kecacod=keca.kecacod
and thak.thakcod=htan.thakcod
and paht.desaco8=htan.desaco8
and paht.thakcod=htan.thakcod
and paht.htanseq=htan.htanseq
and gssu.desaco8=paht.desaco8
and gssu.gssuyea=paht.gssuyea
and gssu.gssunum=paht.gssunum
and shakinde.indecod=inde.indecod
and shak.tsubcod="04"
and shak.shakcod=shakinde.shakcod;