Tim,



I'm having the same problem with Test Track and was wondering if you ever 

found a solution to the problem.



I created my SQL in Access (and it worked fine), but when I put it on an 

ASP page, or pasted it into SQL Query Builder, I received the 

same "Expected Lexical Element not found: <identifier>" error.



If anyone has any idea I'd love to hear it.



Thanks,

Andrew



> I am trying to use a LEFT JOIN  in my SQL statement to join several 

tables 

> in a database. 

> The database is not a .mdb it is for a program called Test Track.

> The error i get is "Expected Lexical Element not found:<indentifier>"