------=_NextPart_000_002B_01C34DF8.C34C94F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Assistance required.
I have 3 tables:
TABLE: client_invoice
- client_id *1(show all from client_invoice, only those w/ info from =
client_info)
- invoice_amount
- invoice_date_due
TABLE: client_info
- client_id *1(show all from client_invoice, only those =
w/ info from client_info)
- client_city
- client_state *2(show all from client_info, only those w/ =
match from client_info)
- client_country *3(show all from client_info, only those w/ =
match from client_info)
- apply_tax
TABLE: tax_zones
- tid
- countries_iso_2 *3 (show all from client_info, only those w/ match =
from client_info)
- tax_zone *2(show all from client_info, only those w/ =
match from client_info)
- tax_amount
- tax_desc
- tax_status
(if I was drawing this on paper, or creating it in access, I would join =
based on the *'s above)
Here's the select query, I'm attempting to use....
SELECT client_invoice.client_id, client_invoice.invoice_amount, =
client_invoice.invoice_date_due, client_info.client_city, =
client_info.client_state, client_info.client_country, =
client_info.apply_tax, tax_zones.countries_iso_2, tax_zones.tax_zone, =
tax_zones.tax_amount, tax_zones.tax_desc, tax_zones.tax_status, =
(1-(tax_zones.tax_amount/100)) AS BillRate, =
if(client_info.apply_tax=3D0,(client_invoice.invoi ce_amount-(client_invoi=
ce.invoice_amount*BillRate)),0) AS Amt_taxed FROM tax_zones RIGHT JOIN =
(client_info RIGHT JOIN client_invoice ON =
client_info.client_id=3Dclient_invoice.client_id) ON =
(tax_zones.tax_zone=3Dclient_info.client_state) AND =
(tax_zones.countries_iso_2=3Dclient_info.client_co untry)
I'm getting the following error: You have an error in your SQL syntax =
near '(client_info RIGHT JOIN client_invoice ON =
client_info.client_id=3Dclient_invoice.c'=20
any ideas as to how to fix the syntax of this query? I'm sure it's =
something simple, but I'm still a newbie to MySQL.
Kevin Michael Reed
kr***@tnolnet.com
President
TNOLnet.com
------=_NextPart_000_002B_01C34DF8.C34C94F0--