select groupId from tbl_SEC_GROUPS where groupTypeCd = 'MRR' and REPLACE( GroupName, ' ', '' ) in ( ) union select groupId from tbl_SEC_GROUPS where groupTypeCd = 'MPR' and REPLACE( GroupName, ' ', '' ) in ( ) SELECT distinct a.FSPro_UserID, a.FirstName, a.LastName, a.title, b.broker_id, b.broker_name, bo.broker_office_id, bo.broker_office_name FROM tbl_FSPro_Members a with (nolock) INNER JOIN tbl_SEC_MemGrpLink sec with (nolock) ON sec.fspro_userid = a.fspro_userid AND sec.groupid IN ( ) INNER JOIN tbl_SMA_BrokerOfficeLink bol with (nolock) ON bol.mfr_id = AND bol.brokerID = a.ownerid AND bol.territoryid IN () INNER JOIN tblBrokerOffices bo with (nolock) ON bo.broker_office_id = bol.brokerOfficeId AND bo.broker_id = bol.brokerId INNER JOIN tblBrokers b with (nolock) ON b.broker_id = bo.broker_Id INNER JOIN tbl_ORG_AttributeTypes mstrType with (nolock) ON mstrType.uniqueid = 'FSPro_UserID' INNER JOIN tbl_ORG_AttributeTypes childType with (nolock) ON childType.uniqueid = 'BrokerOfficeID' INNER JOIN tbl_ORG_AttributeLinks oal with (nolock) ON oal.child_attrid = bol.brokerofficeid AND oal.child_attrTypeId = childType.attrTypeId AND oal.mstr_attrid = a.fspro_userid AND oal.mstr_attrTypeId = mstrType.attrTypeId LEFT OUTER JOIN tbl_FSPro_MembersCoExclude memx with (nolock) ON memx.fspro_userid = a.fspro_userid AND memx.coid = AND memx.coType = WHERE a.FSL_TableCode = 'BRO' AND a.StaffMember = 1 AND a.OwnerID = AND memx.fspro_userid IS NULL AND a.OwnerID > 0 ORDER BY b.broker_name, bo.broker_office_name, a.LastName SELECT distinct a.FSPro_UserID, a.FirstName, a.LastName, a.title, b.broker_id, b.broker_name, bo.broker_office_id, bo.broker_office_name FROM tbl_FSPro_Members a INNER JOIN tbl_SEC_MemGrpLink sec ON sec.fspro_userid = a.fspro_userid AND sec.groupid in ( ) INNER JOIN tblBrokerOffices bo ON bo.broker_office_id = a.primaryOfficeId AND bo.broker_id = a.ownerId INNER JOIN tblBrokers b ON b.broker_id = bo.broker_Id WHERE a.FSL_TableCode = AND a.StaffMember = 1 AND a.OwnerID = ORDER BY b.broker_name, bo.broker_office_name, a.LastName