title: select statement inside insert statement in sql returns multiple rows
body: <p>I have a following structured query in mysql. But its returning a error. Basically, I want to get value from existing table and instert into new table. I tried the following, but got error;</p>
  
  <pre><code>INSERT INTO `table1`(
      `first`,`second`,`third`) VALUES(
  
      (SELECT table2.timemodified FROM `xtable` AS table2,`ytable` AS table3 
          WHERE table3.id = table2.contextid),
  
      (SELECT table4.id FROM `ztable` AS table4,`ytable` AS table3 WHERE table4.id = table3.instanceid),
  
      (SELECT murs.id FROM `table5` AS murs,
      `xtable` AS table2, 
      `wtable` AS table6, 
      `ytable` AS table3, 
      `vtable` AS table7 
      WHERE murs.id = table2.userid AND table6.id = table2.roleid AND table3.id = table2.contextid AND table7.instance = table3.instanceid AND table6.id =3)
  );
  </code></pre>
  
  <p>I tested but the error is : <code>#1242 - Subquery returns more than 1 row</code>. The problem is I am getting more than single record from the <code>select</code> query inside <code>insert</code>. How can I remove such error.</p>