条件改为:
where a.bill_item_code=b.code and
a.charge_status in('3','4') and
a.ledger_sn<>0 and
substring(c.inpatient_no,1,6)=d.inpatient_no and
a.patient_id=c.patient_id and
a.admiss_times=c.admiss_times
where a.bill_item_code=b.code and
a.charge_status in('3','4') and
a.ledger_sn<>0 and
substring(c.inpatient_no,1,6)=d.inpatient_no and
a.patient_id=c.patient_id and
a.admiss_times=c.admiss_times
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货