title: USING Keyword vs ON clause - MYSQL
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/11366006/mysql-on-vs-using">MySQL ON vs USING?</a>  </p>
  </blockquote>
  
  
  
  <p>Query 1:</p>
  
  <pre><code>SELECT *
  FROM users
  JOIN orders ON (orders.user_id = users.user_id)
  WHERE users.user_id = 1;
  </code></pre>
  
  <p>Query 2:</p>
  
  <pre><code>SELECT *
  FROM users
  JOIN orders USING (user_id)
  WHERE user_id = 1;
  </code></pre>
  
  <p>I want to join orders and users tables to get some certain data. It works fine. My issue is since both queries output the same results set, is it the same? Which one is more efficient to be used? Which one is good for performance ? Which one is the best practise ? </p>