急！请问如何在informix中实现以下更新
update CCI aset comm_percent = (select nvl(comm_percent,0)
from AR b
where b.commission_template_id = a.commission_template_id
and b.assess_item_id = a.assess_item_id
and a.amount between b.start_value and b.end_value
and sts = 'A'
)
comm_value = (select nvl(comm_value,0)
from AR b
where b.commission_template_id = a.commission_template_id
and b.assess_item_id = a.assess_item_id
and a.counts between b.start_value and b.end_value
and sts = 'A'
)
where agent_id = 1
and contract_id = 1
and task_id = 1
and employee_id =1
and local_net_id = 1
and count_month = 1
本人对informix sql不太熟，以上的update是在oracle下的，
在 informix下报：
SQL Error (-201): A syntax error has occurred
请问如何在informix中完成该更新
AR表中commission_template_id，assess_item_id ，counts 能唯一确定一条数据
谢谢了！ 呵呵，看到错误原因了，低级错误啊。set后边的两个字段之间缺少了“,”从oracle超过来错了，另外informix sql中update语语法中好像不能用字符串指代需要update的表
改成这样就对了
update CCI
set comm_percent = (select nvl(comm_percent,0)
from AR b
where b.commission_template_id = CCI.commission_template_id
and b.assess_item_id = CCI.assess_item_id
and CCI.amount between b.start_value and b.end_value
and sts = 'A'
),
comm_value = (select nvl(comm_value,0)
from AR b
where b.commission_template_id = CCI.commission_template_id
and b.assess_item_id = CCI.assess_item_id
and CCI.counts between b.start_value and b.end_value
and sts = 'A'
)
where agent_id = 1
and contract_id = 1
and task_id = 1
and employee_id =1
and local_net_id = 1
and count_month = 1 dddddddddddddddd
页:
[1]