title: Join query in MySQL
body: <p>I have two tables: members and renewals</p>
  
  <p>The two tables have a field called memberid which links the two data tables together.  I am trying to construct a query which will extract the firstname and surname from the members table for the data that is being held in the renewals table.  I have tried using the query below which is based on some examples I've looked up.</p>
  
  <pre><code>SELECT members.memberfirst, members.membersurname, members.memberid, renewals.account_name, renewals.memberid 
  FROM members, renewals 
  WHERE renewals.memberid=members.memberid
  </code></pre>
  
  <p>The error I get when trying to run this in phpMyAdmin:</p>
  
  <pre><code>#1267 - Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/lOFDe.jpg" alt="alt text"></p>