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,

          itemid,

          soldon,

          Year(soldon) as Year,

          Month(soldon) as Month,

          Day(soldon) as Day,

          price;

      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?