Hi Chris/Connor,

I have written below SQL to get Difference of Debit & Credit sum (DB version we are using is 11g).
Problem here is I have used two inline views (with similar joins only difference is Bill_Amt_Sign = 1 & Bill_Amt_Sign = 2).

Is there any beyyer way to do this instead going for same tables joins twice.
If you provide any hint, I will try it out. Thanks a lot!!

select DBT.DBAMT - CDT.CRAMT AS Amount
from (select sum(transactionDebit.Bill_Amt) DBAMT
from tb_em_card_transaction transactionDebit,
tb_em_card_demographic_det card
where transactionDebit.Bill_Amt_Sign = '1'
and (
(
transactionDebit.Card_No = card.card_no AND
transactionDebit.Bill_Acc_No = transactionDebit.Txn_Primary_Acc AND
transactionDebit.Memo_Flg = 'N'
)
OR
(
transactionDebit.Txn_Primary_Acc = card.Acc_No and
transactionDebit.Bill_Acc_No != transactionDebit.Txn_Primary_Acc
)
)
and card.Card_No = '123459875'
AND transactionDebit.Txn_Post_Date >= '10/10/2015'
AND transactionDebit.Txn_Post_Date <= '10/10/2016') DBT,
(select sum(transactionCredit.Bill_Amt) CRAMT
from tb_em_card_transaction transactionCredit,
tb_em_card_demographic_det card
where transactionCredit.Bill_Amt_Sign = '2'
and (
(
transactionCredit.Card_No = card.card_no and
transactionCredit.Bill_Acc_No = transactionCredit.Txn_Primary_Acc and
transactionCredit.Memo_Flg = 'N'
)
OR
(
transactionCredit.Txn_Primary_Acc = card.Acc_No and
transactionCredit.Bill_Acc_No != transactionCredit.Txn_Primary_Acc
)
)
and card.Card_No = '123459875'
AND transactionCredit.Txn_Post_Date >= '10/10/2015'
AND transactionCredit.Txn_Post_Date <= '10/10/2016') CDT;