title: How to "insert into table1 (col1, col2) values select col1 from table2 , select col2 from table3"
body: <p>Well I have a question here if it possible to do it. I have a table called "customer" has 2 columns "customer, source".   </p>
  
  <p>And I have 2nd table called "balance" has more than 10 columns, one of the columns called "cname".   </p>
  
  <p>And the 3rd table called info has also more than 10 columns, but only one row that contains the company info, one of the columns called "source".   </p>
  
  <p>So the table are look like the following:   </p>
  
  <p>Table "balance":   </p>
  
  <p><a href="https://i.stack.imgur.com/oXEi8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/oXEi8.png" alt="enter image description here"></a>   </p>
  
  <p>The info table:    </p>
  
  <p><a href="https://i.stack.imgur.com/7BVaY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7BVaY.png" alt="enter image description here"></a>   </p>
  
  <p>So what I want is to insert into customer table from both tables above so the results must be like:    </p>
  
  <p><a href="https://i.stack.imgur.com/Y0cN1.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Y0cN1.png" alt="enter image description here"></a></p>
  
  <p>I have tried the following code, but it gives me an error</p>
  
  <pre><code>insert into customer values 
      select cname 
      from balance, select source from info
  </code></pre>