select mbr.fspro_userid USER_ID, rtrim(mbr.firstName) USER_FIRSTNAME, rtrim(mbr.lastName) USER_LASTNAME, rtrim(mbr.salutation) USER_SALUTATION, rtrim(mbr.title) USER_TITLE, rtrim(mbr.phone) USER_PHONE, rtrim(mbr.fax) USER_FAX, rtrim(mbr.address1) USER_ADDRESS1, rtrim(mbr.address2) USER_ADDRESS2, rtrim(mbr.city) USER_CITY, rtrim(mbr.state) USER_STATE, rtrim(mbr.zipcode) USER_ZIPCODE, rtrim(mbr.organization) USER_ORGANIZATION, case when mbr.fsl_tablecode = 'MFR' then rtrim(mbr.email) else 'RESTRICTED' end USER_EMAIL, mbr.ownerId, mbr.fsl_tablecode, mbr.primaryOfficeId, mbr.staffmember, mbr.officeAddrSame from tbl_SEC_MemGrpLink mgl inner join tbl_FSPro_Members mbr on mbr.fspro_userid = mgl.fspro_userid where mgl.groupid = 4494 SELECT o.mfr_name companyName, o.postal_address address1, o.postal_address2 address2, o.postal_city city, o.postal_state state, o.postal_zip_code zipcode FROM tblManufacturers o WHERE o.mfr_id = SELECT o.broker_name companyName, l.broker_postal_address address1, l.broker_postal_address2 address2, l.broker_postal_city city, l.broker_postal_state state, l.broker_postal_zip zipcode, l.broker_office_name officeName FROM tblBrokers o INNER JOIN tblBrokerOffices l ON l.broker_id = o.broker_id WHERE o.broker_id = AND l.broker_office_id =