title: Left Outer Join - ORA-00933: SQL command not properly ended
body: <p>What is wrong with this query? I just can't get it to execute on a Oracle 11G Database.</p>
  
  <pre><code>SELECT PH.ORD_NBR, PH.TEL_NBR, SM.NAME 
  FROM ORD_HDR PH  
  LEFT_OUTER JOIN STORE SM ON SM.COUNTY='1' AND 
  SM.STORE_ID=PH.STORE_ID  WHERE PH.ORD_NBR='777894801' AND ROWNUM&lt;=1
  </code></pre>
  
  <p>I get this errror</p>
  
  <p><strong>ORA-00933: SQL command not properly ended</strong></p>