Here is the code I am using,
Expand|Select|Wrap|Line Numbers
- select job.Job_No,
- Working_Hrs*Paying_Rate,
- Quantity*Unit_Price
- from job left join labour
- on (job.Job_No=labour.Job_No)
- left join material
- on (job.Job_No=material.Job_No)
Here is the URL for the demo Demo Site
If it asks for a username, its the same as my email
[Email removed]
The password is
1234
You can see that there are two details for the entries in Labour, and one detail for the entry in materials, but when you look on the invoice tab, it has duobled the materials to show two entries, this will increase if the labour entries are added to as well.
This is the final part I need to finish my project, but I have been stuck on this for a good week now, trying inner joins, leftjoins right joins, I tried adding Group by job.Job_No, but this only came back with the first line in the labour entry, so thats no good either.
Please, there must be somebody who can shred some light on this for me.
Thanks in advance
Paul.