Re: [HACKERS] Outer joins

> "OUTER" conveys no additional information, and can be omitted. My copy

Sorry. You're right. Just as long as you accept it.

> I'm not sure what you mean about missing something about "the column
> name for t1". My hypothetical query is referring to column "x",
> present in all four tables. Was there some other place a column for t1
> should be mentioned?

What if the column is named order_id in one table and ord_id in another?

>   select * from t1 left join t2 on t1.x = t2.x
>                    left join t3 on x = t3.x;

OK, this will do it. You can have a t1.x = t2.y.