title: Subquery in a left outer join
body: <p>I have been searching high and low but cannot find a simple solution that I can understand.</p>
  
  <p>I have this query:</p>
  
  <pre><code>select * from table_A
  Left Outer Join Table_B 
  on  table_A.common_column = Table_B.common_column
  and Table_B.column = (select max(id) from table_C where value = :BINDVARIABLE) /*Static Number*/
  </code></pre>
  
  <p>I keep getting the following error:
  ORA-01799: a column may not be outer-joined to a subquery</p>
  
  <p>Any help would be appreciated</p>