title: Count and sum per day multiple tables without join
body: <p>I want count the number of orders invoices delivery and sum the amount of orders invoices delivery per day.
  Like this:</p>
  
  <pre><code>date  nb orders  orders$     nb delivery   
  day1     5        1234,56       3
  day2     6        665,88        7
  ..
  </code></pre>
  
  <p>The first time I tried this, it was ok for one day but not for a week, for example:</p>
  
  <pre><code>SELECT  
    (SELECT COUNT(OPP.OPPNUM_0) FROM OPPOR OPP WHERE OPP.CREDAT_0=%1%),
    (SELECT SUM(OPP.OPPAMT_0) FROM OPPOR OPP WHERE OPP.CREDAT_0=%1%),
    (SELECT COUNT(SQH.SQHNUM_0) FROM SQUOTE SQH WHERE SQH.CREDAT_0=%1%),
    (SELECT SUM(SQH.YCUMHTSEL_0) FROM SQUOTE SQH WHERE SQH.CREDAT_0=%1%),
    (SELECT COUNT(SOH.SOHNUM_0) FROM SORDER SOH WHERE SOH.CREDAT_0=%1%),
    (SELECT SUM(SOH.ORDNOT_0) FROM SORDER SOH WHERE SOH.CREDAT_0=%1%)
  FROM    dual
  </code></pre>