你看看这样行不行:
update B bb set rcpt_no=(select aa.rcpt_no from A aa where aa.visit_date=bb.visit_date and aa.patient_id=bb.patient_id and rownum=1)
where exitst(select null from A where visit_date=tt.visit_date and patient_id=tt.patient_id) and patient_id='1234567'
update B bb set rcpt_no=(select aa.rcpt_no from A aa where aa.visit_date=bb.visit_date and aa.patient_id=bb.patient_id and rownum=1)
where exitst(select null from A where visit_date=tt.visit_date and patient_id=tt.patient_id) and patient_id='1234567'
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货