Lth_comp LTH_SNO Lth_ledgerid Lth_trantype lth_total lth_paid lth_received 3 7 1 PR 10000 10000 0 3 7 5 PR 2000 0 10000 3 8 1 SR 2000 10000 0 3 8 15 SR 3000 0 10000 3 5 3 SL 10000 10000 0 3 5 4 SL 1000 0 10000 3 5 5 SLRCPT 1200 1200 0 3 5 5 SLRCPT 1200 0 1200
Lth_comp LTH_SNO Lth_ledgerid Lth_trantype lth_total lth_paid lth_received 3 7 5 PR 2000 0 10000 3 8 15 PR 3000 0 10000
Select * from ledger_transaction_hdr where lth_Transrlno in (select lth_transrlno from ledger_transaction_hdr where lth_ledgerid=1)
Lth_comp LTH_SNO Lth_ledgerid Lth_trantype lth_total lth_paid lth_received 3 7 5 PR 2000 0 10000 3 8 15 PR 3000 0 10000 3 5 5 SLRCPT 1200 1200 0 3 5 5 SLRCPT 1200 0 1200
join
select * from ledger_transaction_hdr a where lth_sno in (Select lth_sno from ledger_transaction_hdr where lth_ledger_id=1)
select * from Ledger_Transaction_hdr where Lth_trantype ='PR' and lth_paid =0
Select * from ledger_transaction_hdr where lth_Transrlno in (select lth_transrlno from ledger_transaction_hdr where lth_ledgerid=1) and lth_ledgerid<>1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)