19 Replies Latest reply: Nov 18, 2014 12:42 PM by Smaranda Fetila RSS

    where clause in SQL statement

    Smaranda Fetila

      Here is my load statement


      LOAD  eventid,



          Year(soldon) as Year,

          Month(soldon) as Month,

          Day(soldon) as Day,


      SQL SELECT *

      FROM advast

      where soldon>'11/11/2014';


      I get an error saying

      SQL SELECT *

      FROM advast

      where soldon>'11/11/2014'


      I'm not sure what is wrong with my script, without the WHERE clause it works fine.

      Does the where clause just not work in a SQL statement in QV?