select a.*, b.SBROWSEPAGE, b.FPRODPERROW, b.FLISTORDER, b.SFLYPAGE, b.BNOUPLOAD from  
groups a  join  GROUP_EXTRA b on a.WGROUPID = b.WGROUPID 
 where a.WGROUPID = <@KEY@> 
 

