title: #1241 - Operand should contain 1 column(s): why?
body: <p>i want use a subquery in a main query like following:</p>
  
  <pre><code>SELECT distinct(cnt.crid),cu.companyName,m.*,cnt.*,m.submitDate as mSubmitDate 
  from tbl_mahmoleh m,tbl_customer cu,tbl_cntreserve cnt 
  where m.cuID=cu.cuID and m.mBLID=cnt.mBLID and m.cuID='12' 
        and (cnt.crID IN (SELECT DISTINCT(crID) FROM tbl_paymentcnt)) 
        and (cnt.crID IN (SELECT pc.crID, SUM( amount ) AS PaySum 
                          FROM tbl_paymentcnt pc GROUP BY pc.crID HAVING PaySum &lt; '2000'))
  ORDER BY inputDateD
  </code></pre>
  
  <p>but i faced by this error </p>
  
  <blockquote>
    <p>Blockquote  #1241 - Operand should contain 1 column(s)</p>
  </blockquote>