title: T-SQL Join Query
body: <p>I have been trying to write a query for a view but I can't seem to get it... I have two tables that I need to join... but what I need is that for every ID in table 1 I get all records on table 2. For Example:</p>
  
  <blockquote>
    <p><PRE> Table 1       Table 2
    Jhon          Car
    Bill          House
                  Jet
    </PRE></p>
  </blockquote>
  
  <p>I would like to get:</p>
  
  <blockquote>
    <p><PRE>
    Table 3
    Jhon   Car
    Jhon   House
    Jhon   Jet
    Bill   Car
    Bill   House
    Bill   Jet</p>
  </blockquote>
  
  <p></PRE></p>
  
  <p>P.S. Data on both tables can vary.
  P.S.S. Table 1 is actually a Left Outer Join between two other tables where the first table contains the indexes and the second contains the field used to create relation to Table 2.</p>