My two tables look something like this:
fields: userID, memName (and some other non relevant ones)
fields: gameID, memID, review
What I want to do is join the tables so I can match up the memberID of each one to produce the member name.
So for example say the users table looked like this:
1 | akabugeyes
2 | admin
and the reviews table looked like this:
1 |blah | 1
2 |blah2 | 2
I would want them to join like this:
1 |akabugeyes|1 |blah |1
2 |admin |2 |blah2 |2
I've tried this:
SELECT a.review, a.gameID, a.userID, b.memName, b.memID FROM reviews as a, users as b LEFT JOIN users ON a.userID = b.memIDbut that doesn't work right. Any help would be appreciated. Thanks.