got a problem with an ASP.NET (vbscript) page thats driving me mad!
My SQL query is:
SELECT TOP 100 person.first_name, person.last_name, person_type.type FROM person LEFT JOIN person_type ON person.person_ref = person_type.person_ref ORDER BY last_name
it was a lot more complex but i simplfied it down to just one join to try and figure the problem, which is that it causes this error....
Exception Details: Microsoft.Data.Odbc.OdbcException: ERROR  [Sybase][ODBC Driver][Adaptive Server Anywhere]Syntax error or access violation: near 'JOIN' in ...FROM person LEFT [JOIN] (person_type ON...
Ive pasted the query into access and it works fine and if I replace the LEFT for INNER it also works fine.
Any suggestions would be much appriciated as its driving me crazy!