22,300
社区成员




insert into SERV_ClinicJournal(JournalId,BillDepartCode,BillDepartName,DoDepartCode,DoDepartName)
select('6a1d2529-c75e-498d-9795-63dc988de9ed',
(select c.itemcode from serv_clinicitem c where c.itemname=SERV_ClinicJournal.BillDepartName),'妇科门诊',
(select c.itemcode from serv_clinicitem c where c.itemname=SERV_ClinicJournal.DoDepartName),'妇科门诊')