Select 
gr2.WparentGroup2id grparid,
grd.SDESCRIPTION,
gr.*,
gr.wgroupid NEXTID 

from 
groups gr join 
groups gr2 on (gr.WParentGroup2ID = gr2.WGroupid) join 
groups_descriptions grd on gr.WGROUPID = grd.WGROUPID 
where
gr.WGROUPID = <@KEY@>

