select trim(substring(a.IMP_EXTID from 6 for 12)) OPTIONITEMID ,
trim(substring(b.IMP_EXTID from 6 for 12)) OPTIONID ,  groups.wSortno  
 from groups 
join IMP_LINK a on GROUPS.WGROUPID = a.WGROUPID 
join IMP_LINK b on GROUPS.WParentGroup2ID  = b.WGROUPID  where 
groups.WGROUPID = <@KEY@> and a.IMP_SOURCEID = <@SOURCEID@> and b.IMP_SOURCEID = <@SOURCEID@>