syntax error??

nikko50

I can't seem to find the syntax error on the below query??

 #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 ''n' LEFT JOIN usertable user1 ON n . Created_By = user1 . userid LEFT JOIN usert' at line 1 


SELECT n. * , user1.realname, user2.realname AS 'chargedby', shippers.shipper AS 'carrier', employees.name AS 'loadedby'
FROM NSI_History AS 'n'
LEFT JOIN usertable user1 ON n.Created_By = user1.userid
LEFT JOIN usertable user2 ON n.chargedby = user2.userid
LEFT JOIN employees AS 'e' ON n.loadedby = e.id
LEFT JOIN shippers AS 's' ON s.id = n.carrier
WHERE n.orderid = '43968'
ORDER BY n.Created_Date ASC , n.Created_Time ASC

dagon

remove all the quotes around the table aliases

nikko50

you da man!

dagon

seems no one knows when to use single quotes, back ticks or neither when using mysql.

this includes me some of the times, so it one of the things i check first.