ORA-01756: 括号内的字符串没有正确结束 这是什么错?我的select语句运行时都是正确的呀
select t.item_code,t.item_name
from lis.advice_content_person w,
(select item_code, item_name
from hisdict.price_dict
where item_code in
(select item_code
from hisdict.advice_both_fee_dict
where advice_code in
(select advice_code
from hisdict.advice_static_dict
where class_code ='D')))t
where w.check_id=t.item_code
and w.doctor_id='0000001'