> "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.