DerDu/SPHERE-Framework

View on GitHub
Application/Platform/System/Database/ReportingUpgrade/viewContactMail.twig

Summary

Maintainability
Test Coverage
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)))