title: CROSS JOIN vs INNER JOIN in SQL
body: <p>What is the difference between <code>CROSS JOIN</code> and <code>INNER JOIN</code>?</p>
  
  <p><strong>CROSS JOIN:</strong></p>
  
  <pre><code>SELECT 
      Movies.CustomerID, Movies.Movie, Customers.Age, 
      Customers.Gender, Customers.[Education Level], 
      Customers.[Internet Connection], Customers.[Marital Status], 
  FROM   
      Customers 
  CROSS JOIN 
      Movies
  </code></pre>
  
  <p><strong>INNER JOIN:</strong></p>
  
  <pre><code>SELECT 
      Movies.CustomerID, Movies.Movie, Customers.Age, 
      Customers.Gender, Customers.[Education Level], 
      Customers.[Internet Connection], Customers.[Marital Status]
  FROM   
      Customers 
  INNER JOIN 
      Movies ON Customers.CustomerID = Movies.CustomerID
  </code></pre>
  
  <p>Which one is better and why would I use either one? </p>