Does anybody have an idea od outstanding transaction query

Question

To get outstanding count of the data from two tables

Answer 1

Do you mind elaborating on that question? What does the outstanding count mean and what does the tables look like? This would help the community to help you and assist you better.

Answer 2

What do you mean by outstanding transaction ... Is there any extra field/column for it or it is calculated somehow

Answer 3

Raksha Chilhate I didn't got what you want to say..
Explain me properly about "outstanding transaction" because I can't see any column named with date or outstanding transaction

Answer 4

Yes sure

Answer 5

So basically i have 3 tables
1.employee
2.payment
3.deduction
And i have to write a query to get outstanding transaction count for a particular employer i.e 'A200'

Answer 6

Fields are
Employeeid
Paymentcount
Deductioncount
Employercode
Totalpaymentamount
Totaldeductionamount

Answer 7

Yes there are date column