I am trying to create a very simple SQL Expression, but can't seem to get the syntax to be valid. The database connection is to a SQL Server database. If I were to create the query in SQL Server Management Studio, it would be something like
select LastName from People
However, every variant I can think of, based on various examples in books and on-line postings, fails syntax check. These include, among many others:
I have also tried single quotes instead of double quotes. I keep getting the same error:
Database Connector Error: '42000:[Microsoft][ODBC SQL Server Driver][SQL Server] Invalid syntax near the keyword 'select'. [Database vendor code: 156].
Any suggestions as to the proper syntax?