sql - MySQL join error -


The following query gives me an error in phpmyadmin, this looks correct for me, and matches the table / column names accordingly. I have tried many variations (using citing table names, using etc.) with no luck.

  Select GROUP_MEMBER GROUP_MEMBER from group GROUP.group_id = GROUP_MEMBER.group_id WHERE group_owner = 'test';  

Error I'm getting:

1064 - There is an error in your SQL syntax; Check the manual related to your MySQL server version for the correct syntax to use the line 2

"Group" is a SQL-keyword, if you want to use it as a tableline, you have to surround it with a backtick.


Comments