David Witham wrote:
> Is there a way to do left outer joins on more than 2 tables at once
> (3 in my case)? Or do I have to do the first join into a temp table
> and then another join from the temp table to the third table? I can't
> seem to work out the syntax from the User Guide.
SELECT * FROM a LEFT JOIN b ON (...) LEFT JOIN c ON c WHERE ...
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
