24 Replies Latest reply: Jun 12, 2014 12:49 PM by Eduardo Sommer RSS

    Problem with "Where" clause

      Hello everyone

       

      I have the following code that gives me a problem with the "Where" clause:

       

      SQL SELECT "job_nummer",

          jobnr,

          "datum_auftrag",

          Year ("datum_auftrag") as Jahr,

          Month ("datum_auftrag") as Monat

         

      FROM EASY.job where "datum_auftrag" = date;

       

      With the "Where" clause I would like to exclude entries that do not have a date.

       

      Could someone help me with this?

       

      Thank you very much in advance...