Sunday 15 May 2011

Multiple Inner Joins in MySQL? -


I'm trying to do several internal, but with mysql I get the following error

# 1064 - There is an error in your SQL syntax; To use pass on code.code = votes.code, check the manual related to your MySQL server version for the correct syntax. Include code INNER on user ID code.userid = user.gid INNER code.code = votes.code at order date LIMIT 0, 30 on line 2

  SELECT * Include   

Am I doing this right?

Yes missed table name in second:

  Add user to SELECT * FROM code INNER code.userid = user.gid INNER to include vote on codes.code = votes.code    

No comments:

Post a Comment