JOINs with parenthesis 1

[Romanichine]

Can someone tell me where the parenthesis, to separate the joins, should be in the following query?

==============
SELECT *
FROM valid_sales_ids s RIGHT OUTER JOIN direct_services
ON s.sales_id = direct_services.sales_id RIGHT OUTER JOIN client INNER JOIN currencies cur
ON client.currency_id = cur.currency_id INNER JOIN languages l
ON client.language_code = l.language_code INNER JOIN companies
ON client.company_id = companies.company_id LEFT OUTER JOIN valid_terminations v
ON client.termination_code = v.termination_code
ON direct_services.client_id = client.client_id
==============

Thank you,
--
Roman.

 

[bperry]

These things are always tricky, and this one is particularly thorny. I would guess this:

SELECT *
FROM valid_sales_ids s
RIGHT OUTER JOIN direct_services
ON s.sales_id = direct_services.sales_id
RIGHT OUTER JOIN
(
client
INNER JOIN currencies cur
ON client.currency_id = cur.currency_id
INNER JOIN languages l
ON client.language_code = l.language_code
INNER JOIN companies
ON client.company_id = companies.company_id
LEFT OUTER JOIN valid_terminations v
ON client.termination_code = v.termination_code
)
ON direct_services.client_id = client.client_id
---------------------
Hope it works!
bperry