title: Insert into ... values ( FROM SELECT ... FROM ... )
body: <pre class="lang-sql prettyprint-override"><code>insert into tab3(a,b,c,d,e)
  values ( 1, 
           ( select  a  
             from tab2 
             left join tab1 ON tab1.a = tab2.a 
             where tab2.b=&quot;x&quot; ),
           'somting1',
           'somting2',
           'somting3');
  </code></pre>
  <p>the probelm is if the select return more then 1 row this function not working and i get error  &quot;the result is more then 1 row&quot;</p>
  <p>i want if have more then 1 row in result of the select to insert all the row whit the select rutrun but also whit the cost varibel same my code</p>