我有一個 T-SQL 查詢需要更改為 Access 查詢。我嘗試了很多次來改變它但沒有成功
UPDATE T1
SET Cap = ((txg*T2.Cap)/100 ),
IPi=(case when t2.TPi=1 then ((txg*T2.IPiTT)/100) else T1.IPi end)
FROM prg T1
JOIN main T2
ON T1.id = T2.id
where T1.Cap=0
uj5u.com熱心網友回復：
IIF在 Access SQL 中使用：
UPDATE
T1
SET
Cap = txg * T2.Cap / 100,
IPi = IIF(T2.TPi = 1, txg * T2.IPiTT / 100, T1.IPi)
FROM
prg AS T1
INNER JOIN
main AS T2
ON T1.id = T2.id
WHERE
T1.Cap = 0
轉載請註明出處，本文鏈接：https://www.uj5u.com/caozuo/459700.html
上一篇：以編程方式更改所有報告