title: Insert into w/ multiple selects giving ERROR 1242: Subquery returns more than 1 row
body: <p>I have table foo1 with columns UserID,TimeStamp; foo2 with columns userID,Level &amp; table foo3 with columns userID,Timestamp.</p>
  
  <p>I want to INSERT into foo1 all rows from foo3 where the UserID exists in table foo2. </p>
  
  <p>I am getting ERROR 1242: Subquery returns more than 1 row  with the following </p>
  
  <pre><code>INSERT into foo1 (UserID,TimeStamp)
  SELECT  
  (SELECT UserID from foo2 as UserID),
  
  (SELECT foo3.TimeStamp
  from foo3
  inner join foo2
  ON foo3.UserID=foo2.UserID) as TimeStamp
  </code></pre>