Income, Expense Query in SQL Server.

Question

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.