12 Replies Latest reply: Nov 10, 2011 11:40 PM by Vijit Jindal RSS

    select and group by

      Hi:

       

      One simple question, why this script work in tsql (mssql) and not in qlikview

       

      OLEDB

      [Provider=SQLNCLI10.1;Integrated Security=SSPI;Persis ......

       

      SQL

      select

      account,date1,date2,co1,cod2,sum(price)

      from table

      where account != '7777777701'

      group by account, date1, date2, cod1, cod2

       

      Any Idea???

       

      Thanks, regards

      César Estrada