13 Replies Latest reply: Jun 20, 2017 7:06 AM by Anil Babu Samineni RSS

    SQL SELECT SYNTAX

    Morne Schoeman

      Good day,

       

      I have a simple question with probably a simple solution but I keep getting the following script and  error:

       

      /QTQVC/OPEN_STREAM failed after 00:00:00 Key = SQL_ERROR (ID:00 Type:E Number:001 "," is invalid here (due to grammar). contains an invalid character or it is a keyword. (It might be possible to escape it using "!"). Or a space is missing or there is one space too many.)

      SQL Select

      LIFNR,

      GJAHR,

      MONAT,

      BLART,

      SUM(DMBTR) AS [AMOUNT]

      FROM

      BSAK

      WHERE GJAHR = '2018' AND (BLART = 'RE' OR BLART = 'KR')

      GROUP BY LIFNR, GJAHR, MONAT, BLART;

       

      Please assist as I cannot find the problem

       

      Kind regards