title: Using select in select in oracle report query
body: <p>I am creating a new report where I have only one cursor in the report and the report has no paper layout (it goes directly to a CSV format).</p>
  
  <p>I have a query where I need to make a sub query something like </p>
  
  <pre><code>SELECT
           grou.GROUP_ID                            GROUP_ID
           ,grou.group_name                          group_name
           ....
           (((SELECT SUM(nett_instalment_invoice_amount) 
              FROM instalments
              WHERE member_product_id = member_product_id)) subscription)
  FROM
  </code></pre>
  
  <p>....
  and so on....</p>
  
  <p>While compiling report I encounter an error saying </p>
  
  <pre><code>Encountered Symbol SELECT while expecting one of the following symbols:
  (  +  - 
  </code></pre>
  
  <p>can this be helped without adding a group by clause at the end?</p>
  
  <p>As I tried an alternative approach by putting in a group by clause and directly using sum function instead of select (sum()).</p>
  
  <p>Please urgent help needed.</p>
  
  <p>Thanks.</p>