title: how to outer-join Tables using ANSI sql
body: <p>I am working on 2 Tables.  One contains 657 rows matching my filter criteria, and the other contains 193 records.</p>
  
  <p>I successfully joined them using Oracle's "AFAIK" syntax:</p>
  
  <pre><code>select
    ecp.portfolio_acct, ecp.posn_id cost_posn_id, ecp.asset_id 
  from MID_COST_POSITION ecp, MID_CASH_POSITION cas
  where ecp.portfolio_acct = 10183306
    and ecp.portfolio_acct = cas.portfolio_acct(+)
    and ecp.asset_id       = cas.asset_id(+)
  ;
  </code></pre>
  
  <p>However, I cannot seem to replicate these results using ANSI-SQL (or, ISO-sql):</p>
  
  <pre><code>select
    ecp.portfolio_acct, ecp.posn_id cost_posn_id, ecp.asset_id 
  from MID_COST_POSITION ecp
  LEFT OUTER JOIN MID_CASH_POSITION cas
    on ecp.portfolio_acct = cas.portfolio_acct
  where ecp.asset_id      = cas.asset_id
    and ecp.portfolio_acct = 10183306 
  ;
  </code></pre>
  
  <p>I have tried various JOINs without success.  In the 1st example I had to Outer Join 2 separate fields, which I do not know how to accomplish using ANSI-SQL.</p>
  
  <p>I appreciate any guidance anyone can offer.  Thank you!</p>