select companyName, fspro_userid, firstName, lastName, sum( accounts ) accounts from ( select b.broker_name companyName, m.fspro_userId, m.firstName, m.lastName, count(*) accounts from tbl_OPR_ClientOperators opr inner join tbl_Fspro_members m on m.fspro_userid = opr.mfr_bsr_id and m.ownerId = opr.ownerId and m.fsl_tablecode = opr.fsltablecode inner join tblBrokers b on b.broker_id = m.ownerId where nullif( m.email, '' ) is null and m.fsl_tablecode = 'BRO' group by b.broker_name, m.fspro_userId,m.firstName, m.lastName union select mfr.mfr_name, m.fspro_userId, m.firstName, m.lastName, count(*) operatorCount from tbl_OPR_ClientOperators opr inner join tbl_Fspro_members m on m.fspro_userid = opr.mfr_bsr_id and m.ownerId = opr.ownerId and m.fsl_tablecode = opr.fsltablecode inner join tblManufacturers mfr on mfr.mfr_id = m.ownerId where nullif( m.email, '' ) is null and m.fsl_tablecode = 'MFR' group by mfr.mfr_name, m.fspro_userId,m.firstName, m.lastName union select mfr.mfr_name, m.fspro_userId, m.firstName, m.lastName, count(*) distributorCount from tbl_CDR_Distributors opr inner join tbl_Fspro_members m on m.fspro_userid = opr.mfr_bsr_id and m.ownerId = opr.ownerId and m.fsl_tablecode = opr.fsl_tablecode inner join tblManufacturers mfr on mfr.mfr_id = m.ownerId where nullif( m.email, '' ) is null and m.fsl_tablecode = 'MFR' group by mfr.mfr_name, m.fspro_userId, m.firstName, m.lastName union select b.broker_name, m.fspro_userId,m.firstName, m.lastName, count(*) distributorCount from tbl_CDR_Distributors opr inner join tbl_Fspro_members m on m.fspro_userid = opr.mfr_bsr_id and m.ownerId = opr.ownerId and m.fsl_tablecode = opr.fsl_tablecode inner join tblBrokers b on b.broker_id = m.ownerId where nullif( m.email, '' ) is null and m.fsl_tablecode = 'MFR' group by b.broker_name, m.fspro_userId,m.firstName, m.lastName ) x group by companyName, fspro_userid, firstName, lastName order by companyName, lastName, firstName

The following list of Staff Contacts have been assigned as Account Owners (for Operators and or Distributors) but they do not have email addresses.

This causes problems with various email notifications and workflows.

Please have the following clients provide email address for these accounts as soon as possible. If the account is for a "House Account" have them use an appropriate email address. An appropriate email address for a "House Account" might be a catch-all for all CRM notifications or the email address of the Primary Manager for the territory of the "House Account" user. These users DO NOT need to be login enabled.

As of the next release of the software (July 1) users will not be able to assign users without email address as the owners of Operator or Distributors

Company	Last Name	First Name	Accounts
#htmleditformat( companyName )#	#htmleditformat( lastName )#	#htmleditformat( firstName )#	#lsnumberformat( accounts )#