title: SQL INNER JOIN syntax
body: <p>the two bits of SQL below get the same result</p>
  
  <pre><code>SELECT c.name, o.product  
  FROM customer c, order o  
  WHERE c.id = o.cust_id  
  AND o.value = 150  
  
  SELECT c.name, o.product  
  FROM customer c  
  INNER JOIN order o on c.id = o.cust_id  
  WHERE o.value = 150
  </code></pre>
  
  <p>I've seen both styles used as standard at different companies. From what I've seen, the 2nd one is what most people recommend online. Is there any real reason for this other than style? Does using an Inner Join sometimes have better performance?</p>
  
  <p>I've noticed Ingres and Oracle developers tend to use the first style, whereas Microsoft SQL Server users have tended to use the second, but that might just be a coincidence.</p>
  
  <p>Thanks for any insight, I've wondered about this for a while.</p>
  
  <p>Edit: I've changed the title from 'SQL Inner Join versus Cartesian Product' as I was using the incorrect terminlogy. Thanks for all the responses so far.</p>