teejayuu - 5:35 pm on Aug 31, 2010 (gmt 0)

Hi all

I'm just trying to write a query in MySQL that joins 3 tables and am getting the following error

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4

from the following query

SELECT t1.* , t2.name AS repliername, t3.centre_name FROM ((tickets AS t1 LEFT JOIN users AS t2 ON t1.replierid = t2.id) LEFT JOIN centres as t3 ON t3.id = t1.name

Any ideas as I can't find '' in my query