select bo.broker_office_name, bol.primaryOffice, bo.broker_office_id from tbl_SMA_BrokerOfficeLink bol inner join tblBrokerOffices bo on bo.broker_id = bol.brokerId and bo.broker_office_id = bol.brokerofficeid where bol.territoryId = and bol.mfr_id = order by primaryOffice desc, broker_office_name select groupTypeCd, groupName from tbl_SEC_Groups where groupId in ( ) and groupTypeCd in ( 'MRR', 'MPR' ) order by groupTypeCd, groupName

User Groups

#htmleditformat( groupName )# not Operator Selling or Primary Role

#htmleditformat( groupName )#

select broker_office_name, broker_office_id from tblBrokerOffices where broker_office_id in ( )

User Offices

#htmleditformat( qmd_offices.broker_office_name )# Okay not in (#htmleditformat( valueList( qmd_territoryOffices.broker_office_name ))#)