需求说明
结转项目表.结转收入 = 结转项目表.结转金额/(1+税率表.税率)
Sql模板及说明
-- where条件是表名中 表名.ID 在查询结果中存在对应的值才能执行更新语句
UPDATE 表名 SET 表名.字段名=
(SELECT
查询结果.字段名
FROM
( 查询语句 ) 查询结果名
WHERE 表名.ID=查询结果.SYS_ID)
Sql实例
UPDATE ct_mrt_CompanyPrjCarryBill cpb
SET cfcarryNoTaxRec = (
SELECT round(CFReadyCarryAmount / (1 + CFADDEDTAX), 2)
FROM (SELECT a.fid, isnull(a.CFReadyCarryAmount, 0) AS CFReadyCarryAmount,
isnull(b.CFADDEDTAX, 0) AS CFADDEDTAX
FROM ct_mrt_CompanyPrjCarryBill a
LEFT JOIN ct_mrt_ProjectTaxRate b ON b.cfcompany = a.cfcompany
AND b.cfprojectNo = a.cfprojectNo
WHERE a.cfproducttype LIKE '%车位%'
AND a.cfsrcType = '0'
) t
WHERE cpb.fid = t.fid
)