Hi,
Try to change the alias - group is a reserved word and it is causing the syntax error
This one should work
SELECT members.name, gr.id, gr.name
FROM members
LEFT JOIN members AS gr
ON gr.id = members.group_id
WHERE members.id = 6
Dobromir Velev
Web developer
http://www.websitepulse.com/
-
> Here's the simplified query:
>
> SELECT members.name, group.id, group.name
> FROM members
> LEFT JOIN members AS group
> ON group.id = members.group_id
> WHERE members.id = 6
>
>
> And here's the error I get:
>
> You have an error in your SQL syntax near 'group ON group.id =
> me
