Join query in MySQL

Question

I have two tables: members and updates

Two tables have a field called memberid that joins two data tables together. I am trying to build a query that will retrieve the first name and surname from the participants table for the data that is stored in the extension table. I tried using the query below, which is based on some examples that I was looking for.

SELECT members.memberfirst, members.membersurname, members.memberid, renewals.account_name, renewals.memberid 
FROM members, renewals 
WHERE renewals.memberid=members.memberid

Error trying to run this in phpMyAdmin:

#1267 - Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='

Answer 1

INNER JOIN. : http://www.postgresql.org/docs/8.1/interactive/queries-table-expressions.html
PostgreSQL, MySQL, .

SELECT members.memberfirst, members.membersurname, members.memberid, renewals.account_name
FROM members
INNER JOIN renewals
ON members.memberid = renewals.memberid

USING (memberid) ON members.memberid = renewals.memberid

Answer 2

,

SELECT CONCAT(members.memberfirst, " ", members.membersurname) as memberName, 
members.memberid, renewals.account_name, renewals.memberid 
FROM members
INNER JOIN renewals
WHERE renewals.memberid=members.memberid