select distinct c.companyId, c.companyPKeyId ownerId, c.companyPType ownerType, rtrim( case when c.companyPType = 'MFR' then m.mfr_name when c.companyPType = 'BRO' then b.broker_name else '' end ) companyName from tbl_LIB_Accounts a inner join tbl_LIB_Companies c on c.companyId = a.companyId left outer join tblManufacturers m on m.mfr_id = c.companyPKeyId left outer join tblBrokers b on b.broker_id = c.companyPKeyId where c.companyPType in ( 'MFR', 'BRO' ) order by companyName
select ownerId, ownerType from qmd_companyList where companyId = select mfr_Name, m.email, m.firstName, m.lastName, m.lastLoginDate, rtrim( mod.comments ) modComments, mod.moduleId, rtrim( mod.module ) modName from tbl_LIB_Accounts a inner join tbl_LIB_Companies c on c.companyId = a.companyId inner join tblManufacturers mfr on mfr.mfr_id = c.companyPKeyId inner join tbl_FSPro_Members m on m.fspro_userid = a.fspro_userid inner join tbl_LIB_Modules mod on mod.moduleId = a.moduleId where c.companyPType = and c.companyPKeyId = order by m.email
#email# <#firstName# #lastName#>
M#moduleId# #modComments# #modName#