Hello.
What is the correct syntax for several nested tables for left outer join ?

....
select t1.col1, t2.col2, t3.col3
from tab1 t1
left outer join (tab2 t2
.... what should I put here .
left outer join (tab 3 t3) on (t3.col1 = t2.col1)
) on (t1.col1 = t2.col2)

Thanks

.... Especially for mySql.

On 2010-07-06 23:45, Mr. X. wrote:
select t1.col1, t2.col2, t3.col3
from tab t1
left join tab t2
on t1.col1 = t2.col2
left join tab t3
on t2.col1 = t3.col2

Some comments, you don't have to use the word outer in "outer left
join", left join will do. You can skip the parentheses in the on clause

/Lennart

Thank you.

"Lennart Jonsson" <erik.lennart.jonsson (AT) gmail (DOT) com> wrote

ALL infixed join operators are of equal precedence and are executed
left to right, with the usual rules for parentheses. The ON clause
associates with the nearest JOIN of any kind.

So, what did you want to do EXACTLY?