Can anyone tell me what's wrong with this query?

[fergman]

SQL = "SELECT customerName, department, FROM reservations, depList WHERE customerName = '" & customerName & "'"

I'm getting the error:

Microsoft JET Database Engine error '80040e14'

The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.


This is an active server page using vbscript

 

[tlbroadbent]

Remove the comma after department. Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[Transcend]

"SELECT customerName, department, FROM reservations, depList WHERE customerName = '" & customerName & "'"

you have a comma after department which shouldn't be there

Transcend