select c.sdescription LANGEXTID, groups.wSortno, 
 
trim(trim(b.SDescription) || '_' || groups.SDescription) SFileDescription,

 GROUPS_DESCRIPTIONS.* from groups 
join groups b on groups.WPARENTGROUP2ID = b.Wgroupid
 join GROUPS_DESCRIPTIONS on groups.WGROUPID = GROUPS_DESCRIPTIONS.WGROUPID 
join IMP_LINK on GROUPS_DESCRIPTIONS.WLANGUAGEID = IMP_LINK.WGROUPID  
join groups c on IMP_LINK.WGROUPID  = c.Wgroupid 
 where 
groups.WGROUPID = <@WGROUPID@> and IMP_LINK.IMP_SOURCEID = <@SOURCEID@>

