title: ROWNUM not working for LEFT-OUTER-JOIN
body: <p>I am using ROWNUM for fetching 999 rows in the following manner: </p>
  
  <pre><code>SELECT COUNT(*) 
  FROM PS_MMC_JOBDSSOA_MV JOB, PS_MMC_PERDSSOA_MV PER 
  WHERE PER.EMPLID = JOB.EMPLID AND 
  PER.ASOFDATE = (SELECT MAX(PER1.ASOFDATE) FROM PS_MMC_PERDSSOA_MV PER1 
  WHERE PER1.EMPLID = PER.EMPLID AND PER1.ASOFDATE &lt;= SYSDATE) AND 
  JOB.ASOFDATE = (SELECT MAX(JOB1.ASOFDATE) FROM PS_MMC_JOBDSSOA_MV JOB1 
  WHERE JOB1.EMPLID = JOB.EMPLID AND JOB1.ASOFDATE &lt;=SYSDATE) AND ROWNUM&lt;1000;
  </code></pre>
  
  <p>I have re wrote the above sql query using left outer join:</p>
  
  <pre><code>SELECT COUNT(*) 
  FROM PS_MMC_JOBDSSOA_MV JOB LEFT OUTER JOIN PS_MMC_PERDSSOA_MV PER 
  ON (PER.EMPLID = JOB.EMPLID) 
  AND PER.ASOFDATE = ((SELECT MAX(PER1.ASOFDATE) FROM PS_MMC_PERDSSOA_MV PER1 WHERE 
  PER1.EMPLID = PER.EMPLID AND PER1.ASOFDATE &lt;= SYSDATE) 
  AND JOB.ASOFDATE = (SELECT MAX(JOB1.ASOFDATE) FROM PS_MMC_JOBDSSOA_MV JOB1 WHERE 
  JOB1.EMPLID = JOB.EMPLID AND JOB1.ASOFDATE &lt;= SYSDATE)) WHERE ROWNUM &lt;1000;
  </code></pre>
  
  <p>ROWNUM is not working with Outer join. I am getting more than 1000 rows.</p>
  
  <p>Could anybody suggest what I am doing wrong.</p>