title: Join two table twice and return duplicate column name
body: <p>Suppose I have two table  USER and MESSAGE</p>
  
  <pre><code>USER -  id,name
  MESSAGES - id,message_from,message_to,message_message
  </code></pre>
  
  <p>So inorder to join I use this co</p>
  
  <pre><code>SELECT m.*,u1.*,u2.* FROM MESSAGES m
      INNER JOIN USER as u1
         ON(m.message_from = u1.id)  
      INNER JOIN USER as u2
         ON(m.message_to = u2.id)
  </code></pre>
  
  <p>So now when i print_r out the result in codeigniter it doesn't have the user data for the user message_to. </p>
  
  <p>And I guess even if it return data for both user then it should have some <strong>prefixes to differentiate</strong> </p>
  
  <p>So how should I do that ?</p>
  
  <p>Thanks and Regards</p>