MySQL Query problem

[mndwn]

This is my problem query:

SELECT routes.routeid, depart.depart, arrive.arrive FROM arrive, depart, routes INNER JOIN ( depart INNER JOIN routes ON depart.departid = routes.departid ) ON arrive.arriveid = routes.arriveid WHERE ( ( ( routes.routeid ) = 1 ) )

Though it comes up as an error, here is what MySQL said:

You have an error in your SQL syntax near '( depart INNER JOIN routes ON depart.departid = routes.departid ) ON arrive.arr' at line 1

Got any ideas on how I could fix the Query? Thanx

[maniac1aw]

not sure what your solution is, but some advice, ditch the "inner join" thing... it is much easier to just match the keys up in your where clause like this

select a,b from table1,table2 where table1.key=table2.key;

rather than using a join statement

[barand]

Stick with the inner joins, they are more efficient. Plus I think it a lot clearer to keep the search criteria in the WHERE bits and separated from the structure/join criteria.

Try this version :

SELECT routes.routeid, depart.depart, arrive.arrive
FROM ( depart INNER JOIN routes
ON depart.departid = routes.departid )
INNER JOIN arrive
ON arrive.arriveid = routes.arriveid
WHERE ( routes.routeid = 1 )

hth

[mndwn]

Thanx mate, i was having problems joining 2 tables to 1 using the INNER JOIN, so thanx for your help. Much appriciated