Application/Platform/System/Database/ReportingUpgrade/viewContactMail.twig
SELECT
vMTP.TblToPerson_serviceTblPerson AS TblPerson_Id,
vMTP.TblToPerson_Remark AS TblToPerson_Remark,
vMTP.TblType_Name AS TblType_Name,
vMTP.TblType_Description AS TblType_Description,
vMTP.TblMail_Address AS TblMail_Address
FROM ContactMail_{{ ConsumerAcronym }}.viewMailToPerson vMTP
-- (PeoplePerson_{{ ConsumerAcronym }}.viewPerson
-- LEFT JOIN ContactMail_{{ ConsumerAcronym }}.viewMailToPerson vMTP ON ((PeoplePerson_{{ ConsumerAcronym }}.viewPerson.TblPerson_Id = vMTP.TblToPerson_serviceTblPerson)))