Update A INNER JOIN B ON A.RID =B.RID Set A.A1 =(A.A1-B.A1)
要看属于什么数据库 在标准的SQL中是不支持的,不信的话到MySQL Oracle上试试SqlServer 是支持的----------------- 标准的SQL 支持这么写 Update A Set A.A1 =(select (aa.a1 - b.a1) as XX from a as aa ,b where aa.RID =B.RID )---------------- 或者叫级联更新
Update A Set A.A1 =replace(a.a1,b.a1,'') From A , B Where A.RID =B.RID
Set A.A1 =(A.A1-B.A1)
在标准的SQL中是不支持的,不信的话到MySQL Oracle上试试SqlServer 是支持的-----------------
标准的SQL 支持这么写
Update A
Set A.A1 =(select (aa.a1 - b.a1) as XX from a as aa ,b where aa.RID =B.RID )----------------
或者叫级联更新