darkog Posted September 1, 2011 Posted September 1, 2011 V2 redux Can someone help me? batlle for tent I get this error. merci QUERY ERROR: Query was SELECT cb.*,u.*,c.npcid,cy.cityname FROM challengebots cb LEFT JOIN users u ON cb.cb_npcid=u.userid LEFT JOIN challengesbeaten c ON c.npcid=u.userid AND c.userid=1 LEFT JOIN cities cy ON u.location=cy.cityid Quote
Diesl Posted September 2, 2011 Posted September 2, 2011 I'm not 100% sure, but I don't think you can use an AND after a LEFT JOIN .. ON ... especially not the way you used it. For that part, I would put it in the WHERE statement. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.