darkog Posted September 1, 2011 Share 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 Link to comment Share on other sites More sharing options...
Diesl Posted September 2, 2011 Share 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 Link to comment Share on other sites More sharing options...
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.