ASP.NET SQL LEFT JOIN error

DMac · #1 (**permalink**) 08-22-03, 09:54

Hi,
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 [42000] [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!

D

unatratnag · #2 (**permalink**) 08-23-03, 15:19

joins will be different upon which DB you're using

Code:

select select_list 
from table1 {left | right} [ outer] join
        table2
on  predicate 
 [ join restriction]

For example:

Code:

select au_fname, au_lname,  pub_name
from authors left join publishers
on  authors.city = publishers.city

DMac · #3 (**permalink**) 08-27-03, 04:59

So you mean the syntax for doing a join on a sybase db will be different than for doing it in access?

unatratnag · #4 (**permalink**) 08-27-03, 09:49

possibly, i try to avoid access like the plague, but left/right join's can be a pain because they tend to differ langauge to language, does anyone know if there's a SQL standard way?