Select a.WSTOCKOPTIONSID, coalesce(a.FQTYONHAND,0) FQTYONHAND ,coalesce(a.FEXTRAPRICE,0) FEXTRAPRICE,a.WSTOCKID  ,  k1.WITEMOPTIONID || '-' || k1.WITEMOPTIONVALUEID || coalesce(','|| k2.WITEMOPTIONID || '-' || k2.WITEMOPTIONVALUEID,'') 
|| coalesce(','|| k3.WITEMOPTIONID || '-' || k3.WITEMOPTIONVALUEID,'') 
|| coalesce(','|| k4.WITEMOPTIONID || '-' || k4.WITEMOPTIONVALUEID,'') 
|| coalesce(','|| k5.WITEMOPTIONID || '-' || k5.WITEMOPTIONVALUEID,'') STK  from 
STOCKOPTIONS a 
join ITEMOPTIONSVALUES k1 on a.WITEMOPTIONVALUE1ID = k1.WITEMOPTIONVALUEID
left join ITEMOPTIONSVALUES k2 on a.WITEMOPTIONVALUE2ID = k2.WITEMOPTIONVALUEID
left join ITEMOPTIONSVALUES k3 on a.WITEMOPTIONVALUE3ID = k3.WITEMOPTIONVALUEID
left join ITEMOPTIONSVALUES k4 on a.WITEMOPTIONVALUE4ID = k4.WITEMOPTIONVALUEID
left join ITEMOPTIONSVALUES k5 on a.WITEMOPTIONVALUE5ID = k5.WITEMOPTIONVALUEID

where a.WStockid  = <@WSTOCKID@>