title: is there a way to do multiple left outer joins in oracle?
body: <p>Why won't this work in Oracle?</p>
  
  <p>Is there a way to make this work?</p>
  
  <pre><code>FROM table1 a,
       table2 b,
       table3 c
  WHERE a.some_id = '10'
  AND a.other_id (+)= b.other_id
  AND a.other_id (+)= c.other_id
  </code></pre>
  
  <p>I want <code>table1</code> to be left outer joined on multiple tables...</p>
  
  <p>If I try to change it to use an ANSI join, I get compilation errors. I did the following:</p>
  
  <pre><code>FROM table2 b, table3 c
  LEFT JOIN table1 a ON a.other_id = b.other_id and a.other_id = c.other_id
  </code></pre>