I don't understand why this doesn't work:
Code:
SELECT name
FROM page
WHERE page_id IN (
  SELECT page_id
  FROM user_page
)
I know it won't seem to make sense why I would want to do this but this is what i simplified it to and it still didn't work


The error I get is:
Code:
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 'SELECT page_id FROM user_page )' at line 5