view.sql

Delphi6开发的HIS程序

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;