title: What is the correct solution for that query
body: <pre><code>insert into Orders values ('1111',
      (Select CustomerID from Customers where CustomerID = (Select CustomerID from customers where CompanyName= 'erp')),
      (Select EmployeeID from Employees where EmployeeID = (Select EmployeeID from Employees where FirstName  = 'Hello')),
      (Select ShipperID  from Shippers  Where ShipperID  = (Select ShipperID  from Shippers  where CompanyName= 'Ntat')),
      '2014-12-01','2013-12-01','22','22','aa','aa','dd','gs','ga','ga','qq');
  </code></pre>
  
  <p>i am unable to run this Query as i m getting error :</p>
  
  <blockquote>
    <p>Error Code: 1242. Subquery returns more than 1 row</p>
  </blockquote>
  
  <p>Kindly help</p>