现在同一数据库中有两个表main,main11,两个表中的对应字段id,sanddate,sandmoney的值是一致的,现由于某种原因,表main中的sandmoney的值出现了变动,我想用main11中ID号对应相等的sandmoney值来替换,条件如下,日期main.sanddate>='2003-1-1' and main.id=main11.id 替换main的sandmoney值使它等于main11的sandmoney值,请各位高手帮忙
调试欢乐多
update main
set main.sandmoney = mainll.sandmoney
from main,mainll
where main.sanddate>='2003-1-1' and main.id=main11.id
SET main.sandmoney = mainll.sandmoney
FROM main,mainll
WHERE main.sanddate>='2003-1-1' AND main.id=main11.id