| pedro mpa 2006-01-29, 1:23 pm |
| Solved.
Thanks.
-----Mensagem original-----
De: pedro mpa [mailto:mail.pmpa@sapo.pt]
Enviada: domingo, 29 de Janeiro de 2006 18:25
Para: mysql@lists.mysql.com
Assunto: Help on query joining a 3rd table
Hello!
I am building a query to get a monthly total for receipts and receipts plus
TAX.
My problem is the TAX, it can be different for each receipt.
I need help on including and relating each TAX value/id with each receipt,
like receipt_items.price * 1.21 etc.
The tables are like the following example:
Table receipts:
id | id_tax | date
1 1 2005-12-31
2 1 2006-01-01
3 2 2006-01-25
....
Table receipt_items:
id | id_receipt | price (exc tax)
1 1 1000
2 2 1000
....
Table tax:
id | tax (%)
1 19
2 21
So far I have:
SELECT
SUM(receipt_items.price) AS total ,
(SUM(receipt_items.price) * [-help here-]) AS total_plus_tax
FROM
receipt_items, receipts
WHERE
receipt_items.id_receipt = receipts.id
AND MONTH(receipts.date)=".$month."
AND YEAR(receipts.date)=".$year."
Thanks in advance.
Pedro.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mail.pmpa@sapo.pt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
|