title: Get 1 result in first column of the table and get all the results in the second column of the table
body: <p>I have tables like these:</p>
  
  <p><strong>users</strong></p>
  
  <pre><code>   id   |   firstname   |   lastname   |   date   
  --------------------------------------------------
     1    |   paul        |   sy         |   date   
  
     2    |   james       |   curry      |   date   
  
     3    |   kevin       |   leonard    |   date   
  </code></pre>
  
  <p><strong>docs_list</strong></p>
  
  <pre><code>   id   |   user_id   |   url   |   title   |   date   
  -------------------------------------------------------
     1    |      1      |   url   |   title   |   date   
     2    |      2      |   url   |   title   |   date   
     3    |      1      |   url   |   title   |   date   
  </code></pre>
  
  <p>I want to get 1 result of <code>firstname</code> and <code>lastname</code> and all of the results of  <code>url</code> and <code>title</code> <strong>based on where</strong> the <code>users.id</code> and <code>docs_list.user_id</code> is equal to the <strong>id</strong> given <code>ORDER BY docs_list.date DESC</code>.</p>
  
  <p>So this is how I query it:</p>
  
  <pre><code>SELECT users.first, users.last, docs_list.urlcode, docs_list.title
  
  FROM users
  
  INNER JOIN docs_list
  
  ON users.id = docs_list.user_id
  
  WHERE docs_list.user_id = {$value}
  
  ORDER BY docs_list.date DESC
  </code></pre>
  
  <p>Problem is that, I got so many <code>firstname</code> and <code>lastname</code> results (equal to how many rows I have in the <code>docs_list</code> result). I only need 1 <code>firstname</code> and <code>lastname</code>.</p>
  
  <p>So how can I do it?</p>