title: MySQL-insert into one table columns from other tables
body: <p>I need to copy two columns from two different tables into new table:</p>
  
  <pre><code>t1: col1  col2       t2: col3  col4
      a1     b1              c1   d1
      a2     b2              c2   d2
                             c3   d3
  </code></pre>
  
  <p>I need to get this:</p>
  
  <pre><code>t3: col1  col4
       a1    d1
       a2    d2
       null  d3
  </code></pre>
  
  <p>I used query:</p>
  
  <pre><code>INSERT INTO t3 (col1,col4) SELECT t1.col1, t2.col4 FROM t1,t2
  </code></pre>
  
  <p>but i am getting this:</p>
  
  <pre><code>t3: col1  col4
       a1    d1
       a2    d1
       a1    d2
       a2    d2
       a1    d3
       a2    d3
  </code></pre>
  
  <p>Can anyone help? Should I use some other query? Tnx!</p>