10 TIPs - To Become a Good Developer/Programmer
Why Join
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forum guidelines
Basit Khan
1.8k
295
93.2k
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.
Reply
Answers (
2
)
How to use SET NOCOUNT ON in SQL Server
Query not working.