Basit Khan

Basit Khan

  • 1.7k
  • 287
  • 68.5k

Income, Expense Query in SQL Server.

Jul 8 2019 12:16 PM
Hi,
I have three tables. Income, Expense and BankInterTransfer.
Income
IncomeNo
IncomeDate
IncomeDepositeinBank ----> Bank Name will show from Bank Master
IncomeAmount (will add in Bank)
Expense
ExpenseNo
ExpenseDate
ExpenseSupplier
ExpenseAmount (Will deduct)
ExpenseIssueFromBank ----> Bank Name will show from Bank Master
BankInterTransfer
BankInterNo
BankInterDate
BankInterFromBank ----> Bank Name will show from Bank Master
BankInterToBank ----> Bank Name will show from Bank Master
BankInterAmount (Will add from one bank and reduce from another Bank)
BankInterRemark
I want a query where it should show BankName, IncomeAmount, ExpenseAmount and BalanceAmount columns with three tables.
Thanks
Basit.

Brought to you by: JavaScript SDK for Bold BI dashboard and analytics embedding. Free trial.

Answers (2)