SQL query: join two tables

Question

so i get an error on the this sql query, but i can´t see my mistake myself:

SELECT group_members.group_id, 
       group_members.permissions, 
       group.group_name
  FROM group_members, 
       group 
 WHERE group_members.group_id=group.group_id
   AND group.group_id = 1

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 'group WHERE group_members.group_id=group.group_id AND group.group_id = 1

Thanks for your help!

Answer 1

Group is a reserved word in MySQL either enclose it in backticks "`" or better yet do not use it as a table name

SELECT group_members.group_id, group_members.permissions, `group`.group_name
FROM group_members, `group` 
WHERE group_members.group_id=`group`.group_id
AND `group`.group_id = 1

Answer 2

Try this

SELECT group_members.group_id, group_members.permissions, `group`.group_name
FROM group_members, group 
WHERE group_members.group_id=`group`.group_id
AND `group`.group_id = 1