SQL SELECT SYNTAX

[#1]

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

[jonathandienst]

Is GJAHR really a text field? Remove the quotes around the year value.

[Anil_Babu_Samineni]

For funny solution may be here

in ('RE' , 'KR') // I make it as Space over IN operator

[#4]

It seemed that removing all the commas and putting a space after and before the brackets in the WHERE clause ( BLART = 'RE' OR BLART = 'KR' ) did the trick, thank yo for all the help, I appreciate it.

[Anil_Babu_Samineni]

Is that trick make sense? Or still you are expecting some thing from community?

If you got answer as you expected, Better to close this thread by flag correct answer and helpful answers as you feel

Don't hesitate to ask while you get expected result.