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
Post a Comment