CREATE
    ALGORITHM = MERGE
VIEW bd_hospital.view_all_diagnos AS
    SELECT
       id_patient,id_doctor
    FROM
       bd_hospital.diagnosis;