5 Replies Latest reply: Jul 16, 2014 9:51 AM by Gysbert Wassenaar RSS

    Create Set Analysis from SQL Statement

      Hi everybody,

       

      Please what is the equivalent of this SQL Statement in SET Analysis ?

       

      SELECT  Aux.DRADV, SUM(Aux.nbre_de_lignes)

      FROM (

      SELECT DISTINCT dr.Date_de_reception_ADV as DRADV, dd.*

      FROM adv.dataadvagent dr, adv.dataadvagent dd

      WHERE dr.Date_de_reception_ADV < dd.date_de_traitement

      AND dd.Date_de_reception_ADV <= dr.Date_de_reception_ADV

      AND dr.Date_de_reception_ADV IS NOT NULL AND dr.date_de_traitement IS NOT NULL AND dd.Date_de_reception_ADV IS NOT NULL AND dd.date_de_traitement IS NOT NULL

      ) Aux

      GROUP BY Aux.DRADV

      LIMIT 2000

       

      Thanks in advance.