Click here to Skip to main content
15,917,793 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
I have three tables

member
-id
-name
-address


tax_bill
-bill_id
-member_id
-tax_amount

tax_receipt
-receipt_id
-member_id
-bill_id


From above tables i want to show the member details with his bill detail and receipt details. Initially the tax_receipt will be empty, When the user will pay the tax, the entry will be in the tax_receipt detail. I want to create a report in which all the members detail from member table, tax detail from tax_bill and receipt detail from tax_receipt will be displayed. What i want is to show ZERO if the record is not found in tax_receipt table for perticular member's tax_bill details.

Also, i am using join query so it will be usefull if suggestion will be using join query.

Thank you in advance :)

What I have tried:

I have tried with sub query and other but going in vain
Posted
Updated 25-Jul-18 22:30pm

1 solution

 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900