在查询分析器里可用,但在作业里报错
就下面这个句子,在查询分析器里运行的时候没有错误,但在作业里报:
错误208,对象名"tc_customer"无效,"tc_customer"无效
达人帮忙看看
update tc_customer set tc_customer.cust_dec002 = aa.yea from tc_customer ,
(select tc_customer.friend_id,datediff(year,convert(datetime,substring(tc_customer.cust_char004,1,10)),getdate()) yea
from tc_customer
where isdate(substring(cust_char004,1,10)) = 1) as aa
where tc_customer.friend_id = aa.friend_id
and tc_customer.owner_id = 1