view.sql

来自「Delphi6开发的HIS程序」· SQL 代码 · 共 5 行

create or replace view v_doctor as
select doctor.doctorid, doctor.sectionofficeid, doctor.doctorcatalogid, employee.cname, tollstation.tollstationid
from doctor, employee, tollstation
where doctor.employeeid = employee.employeeid and
      doctor.sectionofficeid = tollstation.sectionofficeid;