CREATE ALGORITHM=UNDEFINED DEFINER=rootlocalhost SQL SECURITY DEFINER VIEW hospital_view AS select doid AS iddoname AS namedopassword AS passworddoimage AS imagedohost_id AS host_iddoschool AS schoold

SELECT do.id AS id, do.name AS name, do.password AS password, do.image AS image, do.host_id AS host_id, do.school AS school, do.major AS major, do.phone AS phone, do.wait_nums AS wait_nums, do.department_id AS department_id, do.role AS role, do.status AS status, de.name AS department_name, hos.name AS hospital_name, de.status AS department_status FROM ((doctor do JOIN department de ON do.department_id = de.id) JOIN hospital hos ON hos.id = do.host_id)