title: SQL Query, getting results from 2 different tables
body: <p>I have 2 tables, clients and clients_role.</p>
  
  <p>when i enter in a role, i need it to check the clients_role table to see if there are any entries, if there are, get the user_id from the clients_role then match the user_id to the id in the clients table.</p>
  
  <p>Does this make sense?</p>
  
  <p>if anyone could help, it would be great</p>