update 分部分项 as a left join 定额库 as b on a.定额编码 = b.编码 set a.超高=1
where a.标志='定额' and b.地下室=0
出错提示 near "as ":syntax error
如果不要 as 出错提示
near "a ":syntax error
...全文
412回复打赏收藏
SQLite的这条update语句为什么会出错,麻烦帮看下,谢谢
update 分部分项 as a left join 定额库 as b on a.定额编码 = b.编码 set a.超高=1 where a.标志='定额' and b.地下室=0 出错提示 near "as ":syntax error 如果不要 as 出错提示 near "a ":syntax error