title: joining two tables with nullable foreign key?
body: <p>I created two tables below, and <code>FK_TypeID</code> is nullable in this case. I want to write a query returning me the <em>join</em> of two tables.</p>
  
  <p>if <code>FK_TypeID</code> is <em>NULL</em> for a certain row, the <code>TypeName</code> is also <em>NULL</em>. I am not sure how to go about creating such join statement? </p>
  
  <pre><code>[Actions]
  ActionsID
  Date
  Message
  FK_TypeID //links to the table below
  
  [Type]
  TypeID
  TypeName
  </code></pre>
  
  <p>My current statment looks like this and it simply skips <em>NULL</em>  <code>FK_TypeID</code> rows</p>
  
  <pre><code>SELECT        *
  FROM            Actions 
  INNER JOIN      TypeName ON Actions.FK_TypeID = [Type].TypeID
  </code></pre>
  
  <p>Help would be greatly appreciated!</p>