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=0,(client_invoice.invoice_amount-(client_invoice.invoice_amount*BillRate)),0) AS Amt_taxed FROM tax_zones RIGHT JOIN (client_info RIGHT JOIN client_invoice ON client_info.client_id=client_invoice.client_id) ON (tax_zones.tax_zone=client_info.client_state) AND (tax_zones.countries_iso_2=client_info.client_country) 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=client_invoice.c' 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 [EMAIL PROTECTED] President TNOLnet.com
