Dong Lam Trien

Dong Lam Trien

  • 1.3k
  • 845
  • 88.5k

Error reporting The SELECT statement includes a reserved word?

Aug 13 2020 11:21 PM
In C # .net when running an SQL query to get access data with an error The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect, the problem is incorrect:
  1. SELECT COUNT (MAPB) AS Count  
  2. FROM TABNHANVIEN  
  3. WHERE (HIENAN = 'True'AND (MAPB = 3)  
  4. GROUP BY MAPB;
But I copy this query directly to the access sql query to run normally, with no error, I run another query in C # .Net running normally, no error like this message, you know what is wrong is not?

Answers (2)