title: MySQL saying that column is ambiguous
body: <p>I need to do a query on the same field on a MySQL table but with different parameters.  This is my query.  The issue that comes up is that MySQL is saying that users_name is ambiguous.</p>
  
  <pre><code>SELECT projects_id, 
  projects_users_id,projects_companies_id,projects_name,
  projects_description,project_registered_date,
  projects_users_id_register,
  users.users_name as userInCharge,companies.companies_name as company,
  users.users_name as user_register FROM projects 
  LEFT JOIN users as userInCharge ON (users_id = projects_users_id) 
  LEFT JOIN users as register ON (users_id=projects_users_id_register)
  LEFT JOIN companies ON (companies_id = projects_companies_id) ORDER BY projects_id DESC 
  </code></pre>
  
  <p>My goal is to get the ID of both the person in charge of the project and the person who registered the project.  How do I do this?</p>