title: Is Join syntax different in SQL Server 2012?
body: <p>I'm new to SQL Server and I'm using SQL Server Managment Studio 2012. I'm trying to do a very basic join, and I even copyed the syntax from an instruction video on PluralSight (using SQL Server 2008). Yet it does not excute.</p>
  
  <p>This is the query:</p>
  
  <pre><code>USE [TestDB];
  
  SELECT * FROM  Cities JOIN Persons 
  </code></pre>
  
  <p>This is the message:</p>
  
  <blockquote>
    <p>Msg 102, Level 15, State 1, Line 3<br>
    Incorrect syntax near 'Persons'.</p>
  </blockquote>
  
  <p>The thing is when I use a "cross join" it seems to work fine with the expected results.
  What am I doing wrong? And if I'm not doing anything wrong what could be the problem?</p>