请帮忙看以下代码,要怎么写才可以
主要是先将两个表RDRECORD和RERECORDS按ID号相同的连接起来,再将符合几个条件的记录进行UPDATE。
但一直出现标题中的错误,不能执行。
请大家帮忙,多多指教。UPDATE RdRecords
SET iunitcost='0',iprice='0'
WHERE right(rdrecords.cinvcode,1)='C'
AND rdrecord.ddate in (SELECT RdRecord.cBusType, RdRecord.cCode, RdRecord.dDate,RdRecords.*
FROM RdRecord INNER JOIN
RdRecords ON RdRecord.ID = RdRecords.ID
and rdrecord.ddate between '2011-01-01 0:00:00' and '2011-03-31 0:00:00')
主要是先将两个表RDRECORD和RERECORDS按ID号相同的连接起来,再将符合几个条件的记录进行UPDATE。
但一直出现标题中的错误,不能执行。
请大家帮忙,多多指教。UPDATE RdRecords
SET iunitcost='0',iprice='0'
WHERE right(rdrecords.cinvcode,1)='C'
AND rdrecord.ddate in (SELECT RdRecord.cBusType, RdRecord.cCode, RdRecord.dDate,RdRecords.*
FROM RdRecord INNER JOIN
RdRecords ON RdRecord.ID = RdRecords.ID
and rdrecord.ddate between '2011-01-01 0:00:00' and '2011-03-31 0:00:00')
SET iunitcost='0',iprice='0'
WHERE right(rdrecords.cinvcode,1)='C'
AND rdrecord.ddate in (SELECT RdRecord.dDate FROM RdRecord INNER JOIN
RdRecords ON RdRecord.ID = RdRecords.ID
and rdrecord.ddate between '2011-01-01 0:00:00' and '2011-03-31 0:00:00')
SET iunitcost='0',iprice='0'
WHERE right(rdrecords.cinvcode,1)='C'
AND exists (SELECT 1 from RdRecord where RdRecord.ID = RdRecords.ID
and ddate between '2011-01-01 0:00:00' and '2011-03-31 0:00:00')
现在又出现以下错误:
无法绑定由多个部分组成的标识符 "rdrecord.ddate"。
SET iunitcost='0',iprice='0'
WHERE right(rdrecords.cinvcode,1)='C'
AND exists (SELECT 1 from RdRecord where RdRecord.ID = RdRecords.ID
and ddate between '2011-01-01 0:00:00' and '2011-03-31 0:00:00')