title: The result of a scalar fullselect, SELECT INTO statement, or VALUES INTO statement is more than one row
body: <p>I have a problem about my query and i dont know what to do about it.Here is my query.and error i take.</p>
  
  <pre><code>select prd.product_id,prd.prd_name ,prd.prd_longname ,prd.prd_brand ,prd.prd_picture ,prd.market_comment ,prd.categ ,prd.status_id ,prd.status ,prd.active_stock ,prd.slot_date ,prd.currency ,prd.selling_price ,prd.old_price ,prd.type_of_sell ,prd.catalog_id ,prd.catalog_name ,prd.demo ,prd.demo_id, 
      (select coalesce(count(prd_attribute_id),0) from PRD_ATTRIBUTE where status_id = 1 and product_id = prd.product_id and batch_code &lt;&gt; '0000') as ATTR_CNT  ,
      (select prd_attribute_id from PRD_ATTRIBUTE where product_id = prd.product_id and batch_code = '0000' and status_id = 1),
      (select categ_url from DBNAME.PRD_CATEGORY 
  where parameter_id = prd.categ_id)||'/'||    (select prd_url from DBNAME.PRODUCT_URL where product_id = prd.product_id) as CATEG_URL 
  from TEMP_WEB_PRD prd 
  order by slotdate desc
  fetch first 12 rows only
  </code></pre>
  
  <p>Error:</p>
  
  <pre><code> [IBM][CLI Driver][DB2/AIX64] SQL0811N  The result of a scalar fullselect, SELECT INTO    statement, or VALUES INTO statement is more than one row.  SQLSTATE=21000
  </code></pre>