I have three tables.
I want a query which shows all the students who have not payed their amount till the term1duedate based on ther termno.
Some students may have concession. The Query should calculate amount for a student who have the concession and that should check with total amount payed by that student(receipts) till date in that term(1/2/3) is less than the actual amount to be payed in that term(from feedetails).
Pls give me the query.
Any suggession is greatly appreciated.