一个简单SQL的UPDATE问题

SQL code

with  a  as    （select distinct charge_code,supplyer            from yp_in_detl                 where supplyer is not null                     and supplyer <>'111111'                    and supplyer <>''                    and charge_code not exists('015217','014747','015325','015360','015318','015215','015178','015098','015215','015178','015199','015106','015092','015082','015004','015028','015049','015018','014996','014926','014888','014859','014877','014846','014840','014834','014836','014827','014829','014830','014821','014813','014800','014776','014797','014758','014744','014731','014681','014672','014650','007084','014643','014631','014634','013828','013477','013620','014409','013064','007605','007103','007551','007382','005839','007068','014654','014746'))update yp_dict  set trad_mark=a.supplyer where charge_code=a.charge_code错误提示：无法绑定由多个部分组成的标识符 "a.charge_code"。改成下面的语句可以吗？with  a  as    （select distinct charge_code,supplyer            from yp_in_detl                 where supplyer is not null                     and supplyer <>'111111'                    and supplyer <>''                    and charge_code not exists('015217','014747','015325','015360','015318','015215','015178','015098','015215','015178','015199','015106','015092','015082','015004','015028','015049','015018','014996','014926','014888','014859','014877','014846','014840','014834','014836','014827','014829','014830','014821','014813','014800','014776','014797','014758','014744','014731','014681','014672','014650','007084','014643','014631','014634','013828','013477','013620','014409','013064','007605','007103','007551','007382','005839','007068','014654','014746'))update yp_dict  set trad_mark=(select supplyer from  a) where charge_code=(select  charge_code from  a)另外，这个语句可以怎么优化修改下 

SQL code

update b  set trad_mark=a.supplyer from yp_dict b,a where charge_code=a.charge_code
[解决办法]
SQL code
update update b  set trad_mark=a.supplyer inner join yp_dict b on b.charge_code=a.charge_code