title: FULL OUTER JOIN vs. FULL JOIN
body: <p>Just playing around with queries and examples to get a better understanding of joins.  I'm noticing that in SQL Server 2008, the following two queries give the same results:</p>
  
  <pre><code>SELECT * FROM TableA
  FULL OUTER JOIN TableB
  ON TableA.name = TableB.name
  </code></pre>
  
  <hr>
  
  <pre><code>SELECT * FROM TableA
  FULL JOIN TableB
  ON TableA.name = TableB.name
  </code></pre>
  
  <p>Are these performing exactly the same action to produce the same results, or would I run into different results in a more complicated example?  Is this just interchangeable terminology?</p>