sql语句错误，帮忙看下问题在哪

update Chongzhi set JinE=(select JinE from Chongzhi where Id=12) where ID=1;
access中

http://www.jb51.net/article/53835.htm

(select JinE from Chongzhi where Id=12)的值单独发sql查出来，再作为参数传到update语句中

我一般会先定义一个变量接受(select JinE from Chongzhi where Id=12)的值