CREATE
    ALGORITHM = TEMPTABLE
VIEW bd_hospital.view_all_patients_and_doctors AS
    SELECT
        pt.name AS pt_name, dc.name AS doc_name
    FROM
        bd_hospital.patient
            JOIN
        bd_hospital.doctor ON (bd_hospital.doctor.id = patient.id_doctor
            OR patient.id_doctor = NULL)
            JOIN
        bd_hospital.person AS pt ON (pt.id = bd_hospital.patient.id_person
            OR bd_hospital.patient.id_person = NULL)
            JOIN
        bd_hospital.person AS dc ON (bd_hospital.doctor.id_person = dc.id)
    GROUP BY bd_hospital.patient.id;