title: Mysql query JOIN query, getting same column comparing id with request1 and and request2
body: <pre><code>select pr.REQUEST_ID, pr.REQUESTER_ID, pr.REQUEST_SUBJECT, pr.REQUEST_TO, pr.DOMAIN_ID,pr.SUB_DOMAIN_ID, do.domain_name, sd.sub_domain_name, ud.user_first_name, d.user_last_name 
  from professional_requests as pr 
    INNER JOIN domain as do 
      ON do.domain_id=pr.DOMAIN_ID 
    INNER JOIN subdomain as sd 
      ON sd.sub_domain_id=pr.SUB_DOMAIN_ID 
    INNER JOIN user_details as ud 
      ON ud.user_id = pr.REQUEST_TO 
         ud.user_id = pr.REQUESTER_ID 
  where pr.IS_ACTIVE='1' 
  limit 0, 10
  </code></pre>
  
  <p>I need to take out <code>user_first_name</code> and <code>user_last_name</code> from the table <code>user_details</code> twice comparing with <code>user_details.user_id = professional_requests.REQUEST_TO</code> and <code>user_details.user_id = professional_requests.REQUESTER_ID</code> </p>
  
  <p>Problem is I can only get <code>user_first_name, user_last_name</code> of <code>REQUEST_TO</code>, I cannot get them of <code>REQUESTER_ID</code>.</p>