select grl.SDESCRIPTION LANGEXTID,
 groups.wSortno,  GROUPS_DESCRIPTIONS.* from groups join GROUPS_DESCRIPTIONS 
on groups.WGROUPID = GROUPS_DESCRIPTIONS.WGROUPID 
join IMP_LINK on GROUPS_DESCRIPTIONS.WLANGUAGEID = IMP_LINK.WGROUPID
join groups grl on GROUPS_DESCRIPTIONS.WLANGUAGEID   = grl.WGROUPID
   where 
groups.WGROUPID = <@WGROUPID@> and IMP_LINK.IMP_SOURCEID = <@SOURCEID@>