0 Replies Latest reply: Apr 26, 2012 3:40 AM by silviu andries RSS

    Problem transforming group by script in QV expression

    silviu andries

      Hello everyone,

       

      I have a problem with the following SQL code...

      I must transform it into the expression language, and I don't know how this can be done...

       

      Please help me with this.

       

      select count(distinct a.claimid)

      FROM Dauna a INNER JOIN

      (select ClaimId, Max(ReportingDate) ReportingDate

      FROM Dauna

      WHERE ReportingDate<= '20111231' GROUP BY ClaimId) b ON a.ClaimId = b.ClaimId AND a.ReportingDate= b.ReportingDate

      WHERE a.RezervaRamasa != 0