title: COGNOS report for a simple sub query and join Query
body: <p>Here is my query. I am new to Cognos and using Cognos 10. And I am having a bit difficulty in developing a report which uses a Sub Query and an Inner Join Query.</p>
  
  <p>1.</p>
  
  <pre><code>SELECT ID, BATCH_DT, LOCIT FROM AOI.TEMP_BRICK
               WHERE BATCH_DT &lt; (SELECT MAX(DATE) FROM CALENDAR)
  </code></pre>
  
  <p>2.</p>
  
  <pre><code>SELECT A.ID, B.SAL FROM TABLE as A LEFT OUTER JOIN TABLE as B
           WHERE A.ID=B.ID
  </code></pre>