Home > Net >  Incorrect syntax near the keyword 'WHERE' can't fixed
Incorrect syntax near the keyword 'WHERE' can't fixed

Time:06-10

It's just an simple starting but still get that mistake what should I do? I have SQL Server 2019

SELECT *
FROM .CUSTOMER 
WHERE CİTY='SAMSUN'

RESULT

Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'WHERE'.

Completion time: 2022-06-10T01:07:22.2091262 03:00

CodePudding user response:

First the .CUSTOMER should just be CUSTOMER and second, your CITY has a funny I, it is CİTY.

Not sure what İ is? Looks like an I with a dot over it. If I do a find in my editor and put in an I it doesn't match.

CodePudding user response:

Ow sory i just try to do something different. I deleted that period but i still get that result. And if i try that column: SELECT * FROM CUSTOMER WHERE CUSTOMERNAME = 'Salih FAYDALI'

Still get that warning: Msg 156, Level 15, State 1, Line 2 Incorrect syntax near the keyword 'WHERE'.

Completion time: 2022-06-10T01:19:55.3479563 03:00

  • Related