title: sql, sqlite SELECT with inner join
body: <p>I'm wondering how to select one column twice using an inner joinor some other way. my database is sqlite and i use PDO db driver.</p>
  
  <p>My Example:</p>
  
  <pre><code>    SELECT
              orders.id,
              orders.order_number,
              clients.first_name,
              clients.last_name,
              users.name AS user_name
      FROM orders
  
      INNER JOIN clients ON
              orders.client_id = clients.id
  
      INNER JOIN users ON
              orders.created_by = users.id
  </code></pre>
  
  <p>I want to get also, the user_name who edited this record</p>
  
  <pre><code>            orders.edited_by = users.id
  </code></pre>
  
  <p>How to join this selection?</p>