title: Mysql sub query multiple rows returned
body: <p>I've gone through many links already but none could solve my problem. So please don't say that it shows less effort though I've worked on MySql before but never came across this situation where I need to use sub-query.
  So, here's my doubt..</p>
  
  <pre><code>"SELECT * FROM klms as Klm WHERE gcil_id = (SELECT id FROM gcils WHERE genre = 'Clothes')"
  </code></pre>
  
  <p>Obviously I've more than >1 rows where genre = 'Clothes' so it'll return >1 rows.. but then it shows this error</p>
  
  <pre><code>Error: SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row
  </code></pre>
  
  <p>btw I'm using cakephp for my app &amp; I find it easier to use SQL queries.</p>