title: What is the default T-SQL JOIN behaviour, INNER or OUTER?
body: <p>This question was asked for <a href="https://stackoverflow.com/questions/4418776/what-is-the-default-mysql-join-standalone-inner-or">MySQL</a> already, but for Transact-SQL, what is the default <code>JOIN</code> behaviour?</p>
  
  <p>That is, is simply writing <code>JOIN</code> in a query synonymous with writing <code>INNER JOIN</code> (as is the case with MySQL), or something else, like perhaps <code>FULL OUTER JOIN</code>?</p>