select first 1
coalesce(grd.SDESCRIPTION,gr.SDESCRIPTION) SDESCRIPTION,
gr.*

from  
groups gr left join 
groups_descriptions grd on gr.WGROUPID = grd.WGROUPID 
where 
gr.WGROUPID = <@WGROUPID@>

