I have the same Expected Lexical Element not found: <identifier>" error. 
Someone have a solution ?
Tks in advance

Jean

> 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>"