select distinct m.fspro_userid from tbl_SEC_Groups g inner join tbl_SEC_MemGrpLink mgl on mgl.groupId = g.groupId inner join tbl_FSPro_Members m on m.fspro_userid = mgl.fspro_userId where g.ownerId = and g.fsl_tablecode = and g.groupId = select 1 displayRank, * from qmd_opportunities where statusCode <> 'R' select 99 displayRank, * from qmd_opportunities where statusCode = 'R' select * from qmd_viableOpportunities union select * from qmd_lostOpportunities order by displayRank, quantityAmt desc