iam having 3 seperate tables . these 3 tables are interconnected with one key value. i want the record exists in this table Loln_LnDisbmntPaymntDet but not available in
this Lgen_HTHBankRevfeed_D_New and this Loln_BulklnPay table how to write query.
select * from Loln_LnDisbmntPaymntDet where lnno='GYDM2SP1708120005'
select * from Lgen_HTHBankRevfeed_D_New where ProposalNo ='GYDM2SP1708120005'
select * from Loln_BulklnPay where lnno='GYDM2SP1708120005'