select t.item_code,t.item_name from lis.advice_content_person w, (select item_code, item_name from hisdict.price_dict b where exists(select 1 from hisdict.advice_both_fee_dict a where item_code=b.item_code and exists(select 1 from hisdict.advice_static_dict where a,advice_code=advice_code and class_code ='D'))) t where w.check_id=t.item_code and w.doctor_id='0000001'
本来是进来看问题的,但看见好多星星呀... :) 试试用 ed 编辑一下,再运行。在 SqlPlus 有时在有许多字符换行时,有误判。
from lis.advice_content_person w,
(select item_code, item_name
from hisdict.price_dict b
where exists(select 1 from hisdict.advice_both_fee_dict a
where item_code=b.item_code and exists(select 1 from hisdict.advice_static_dict where a,advice_code=advice_code and class_code ='D'))) t where w.check_id=t.item_code
and w.doctor_id='0000001'
试试用 ed 编辑一下,再运行。在 SqlPlus 有时在有许多字符换行时,有误判。