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",



          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...