Question about SQL syntax

31 Views

Hi,

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:

select "People"."LastName"

from "People"

select "People"."LastName"

from "PiapDB_ss5"."dbo"."People"

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?

Thanks.

Dan