select first 1 coalesce(a.sdescription,b.sdescription) sdescription ,
a.FSELLINGPRICE1 * coalesce(unit.FUNITQTY,1) FSELLINGPRICE1,0 WACCOUNTID, coalesce(unit.FUNITQTY,1) UNITQTY,'' CALCQTY,
a.*  
 from stock a left join STOCK_DESCRIPTIONS b
on a.wstockid = b.wstockid
 left join UNIT on unit.WUNITID = a.WUNITID
 where a.wstockid = <@WSTOCKID@>