Thread: Left outer join on multiple tables

Hi all,

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
intoa temp table and then another join from the temp table to the third table? I can't seem to work out the syntax from
theUser Guide. 

Thanks,

David Witham
Telephony Platforms Architect
Unidial
Ph: 03 8628 3383
Fax: 03 8628 3399

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