SQL 修改字段,必须一句答:Access:update A set col1=IIf(b.col2>5, 'Y', 'N')from A, B where a.id=b.id MS SQL:update A set col1=(case when b.col2>5 then 'Y' else 'N' end)from A, B where a.id=b.id Oracle:update A set col1=decode(sign(b.col2-5), 1, 'Y', 0, 'N', -1,...