title: SQL Cross Join with null values
body: <p>I have a table AddressTypes with 4 records (home,office,vacation,hotel) and a table Address that share the filed addresstypeid.</p>
  
  <p>In address table I have 1 record of type "home" and i want a query where I get 4 rows like this:</p>
  
  <pre><code>Type     Address1  Address2 City    State
  
  home     piping    1232     Austin  Tx
  office   null      null     null    null
  vacation null      null     null    null
  hotel    null      null     null    null
  </code></pre>
  
  <p>Here is an image of tables: <a href="http://tinypic.com/view.php?pic=28078xv&amp;s=6" rel="nofollow">http://tinypic.com/view.php?pic=28078xv&amp;s=6</a></p>
  
  <p>Im sure is something very easy maybe using cross join but dont get it. Hope someone can guide me. Appreciate in advance.</p>