> 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 = > members.group_id WHERE members.id = 6' at line 3
group is a reserved word. Use a different alias for the table. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
