FULL JOIN with 3 or more tables - Mailing list pgsql-sql

I can do full joins just fine on two tables at a time:

FROM t1 FULL JOIN t2 ON (t1.id = t2.id)

Now, how would I full joint in a third table?

FROM t1 FULL JOIN t2 ON (t1.id = t2.id) FULL JOIN t3 ON t1.id = t3.id

That previous line would not join together two rows from t2 and t3.


Thanks,

Mike