DerDu/SPHERE-Framework

-- viewGroupProspect
SELECT DISTINCT
    vPGM.TblMember_serviceTblPerson AS TblPerson_Id,
--     vP.TblSalutation_Salutation,
--     vP.TblPerson_FirstName,
--     vP.TblPerson_SecondName,
--     vP.TblPerson_LastName,
--     vPMC.TblCommonGender_Name,
    DATE_FORMAT( vPMP.TblProspectAppointment_ReservationDate, '%d.%m.%Y' ) AS TblProspectAppointment_ReservationDate,
    DATE_FORMAT( vPMP.TblProspectAppointment_InterviewDate, '%d.%m.%Y' ) AS TblProspectAppointment_InterviewDate,
    DATE_FORMAT( vPMP.TblProspectAppointment_TrialDate, '%d.%m.%Y' ) AS TblProspectAppointment_TrialDate,
    vPMP.TblProspectReservation_ReservationYear,
    vPMP.TblProspectReservation_ReservationDivision,
    vSTA.TblType_Name AS TblType_NameA,
    vSTB.TblType_Name AS TblType_NameB,
    vPMP.TblProspect_Remark

FROM
    PeopleGroup_{{ ConsumerAcronym }}.viewPeopleGroupMember vPGM
    LEFT JOIN PeoplePerson_{{ ConsumerAcronym }}.viewPerson vP ON vP.TblPerson_Id = vPGM.TblMember_serviceTblPerson
    LEFT JOIN PeopleMeta_{{ ConsumerAcronym }}.viewPeopleMetaProspect vPMP ON vPMP.TblProspect_serviceTblPerson = vPGM.TblMember_serviceTblPerson
    LEFT JOIN PeopleMeta_{{ ConsumerAcronym }}.viewPeopleMetaCommon vPMC ON vPMC.TblCommon_serviceTblPerson = vPGM.TblMember_serviceTblPerson
    LEFT JOIN EducationSchoolType_{{ ConsumerAcronym }}.viewSchoolType vSTA ON vSTA.TblType_Id = vPMP.TblProspectReservation_serviceTblTypeOptionA
    LEFT JOIN EducationSchoolType_{{ ConsumerAcronym }}.viewSchoolType vSTB ON vSTB.TblType_Id = vPMP.TblProspectReservation_serviceTblTypeOptionB
WHERE
    vPGM.TblGroup_MetaTable = 'PROSPECT'