whats the matter with this query?

[mystrymaster]

SELECT coursereview.ID, coursereview.courseid, coursereview.review, coursereview.image, coursereview.userid, coursereview.name, course.city, course.state phpbb_users.username
FROM coursereview, course, phpbb_users
WHERE coursereview.id >= 4
LEFT JOIN (coursereview.courseid = course.id)

MySQL said:

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 '.username FROM coursereview, course, phpbb_users WHERE coursere

[paul088]

missing coma after course.state?

[siwis]

Could it be:

SELECT
coursereview.ID, coursereview.courseid, coursereview.review, coursereview.image, coursereview.userid, coursereview.name, course.city, course.state, phpbb_users.username
FROM coursereview
LEFT JOIN course ON coursereview.courseid = course.id
LEFT JOIN phpbb_users ON coursereview.commonlinkfield = phpbb_users.commonlinkfield
WHERE coursereview.id >= 4

Your original query has no explicit join between tables "coursereview" and "phpbb_users" therefore MySQL cannot select data from phpbb_users