select * from tbl_FSPro_Members where OwnerID = 173 and FSL_TableCode = 'MSC' and FSPro_UserID in ( select FSPro_UserID from tbl_SEC_MemGrpLink where GroupID = 11293 ) select fspro_userId from tbl_FSPRO_Members where ownerId = 173 and fsl_tablecode = 'MSC' and firstName = and lastName = select * from tbl_SEC_MemGrpLink where groupId = 11293 and fspro_userId = insert into tbl_SEC_MemGrpLink ( fspro_userId, groupId ) values ( , )