title: Insert two columns from two different tables into another table in SQL
body: <p>I have been searching for a solution to my problem for quite a bit, but couldn't find anywhere. 
  Here is my problem: I have two columns from two different tables and want to insert them into another table which is empty. I have tried to run this query but it doesn't work and I don't even know why: </p>
  
  <pre><code>SELECT a.column, c.column 
  FROM FirstTable.column a, SecondTable.column c
  left outer join ThirdTable.column b on a.column = b.column
  left outer join ThirdTable.column b on c.column = b.column
  </code></pre>
  
  <p>After running this, I receive the following message: </p>
  
  <pre><code>Msg 4104, Level 16, State 1, Line 3
  The multi-part identifier "a.column" could not be bound.
  Msg 1011, Level 16, State 1, Line 1
  The correlation name 'b' is specified multiple times in a FROM clause.
  </code></pre>
  
  <p>I would also like to add that a.column has 1143 rows, and c.column has 2057 rows. Both are PK for their respective tables.</p>
  
  <p>Any help would be more than appreciated.</p>