NoHT beda tgl dibook dan regdi

select distinct a.ditahun HTTahun, a.dinomor HTNomor, a.ditanggal TGLDIBOOK, b.ditanggal TGLREGDI
from dibook a, regdi b
where a.ditahun = b.ditahun(+)
and a.dinomor = b.dinomor(+)
and a.dikode = 'DI312C'
and a.ditahun = 2007
order by to_number(a.dinomor);

select * from regdi
where dikode = 'DI312C'
and ditahun = 2007
order by to_number(dinomor);

select * from dibook
where dikode = 'DI312C'
and ditahun = 2007
order by to_number(dinomor);

select * from register a, regdi b
where a.regid = b.regid
and a.regid = '1845e07b6111472e93cbab5faff1f0bf';