一个ACCESS数据库语句转换SQL语句问题

代码如下：

UPDATE    TT_PartsInventory INNER JOIN
                      [TT_InventoryTable-Parts] ON TT_PartsInventory.[Parts/Material No] = [TT_InventoryTable-Parts].[Parts No]
SET              [TT_InventoryTable-Parts].[Difference Rate] = IIf(([Result Stocktaking Quantity] <> 0 AND [PRE-Stocktaking Quantity] <> 0 AND
                      [PRE-Stocktaking Quantity] <> [Result Stocktaking Quantity]), Format((([Result Stocktaking Quantity] / [PRE-Stocktaking Quantity]) - 1) * 100, [#,###.###]), 0)

我已经修改一部分了，但是联接那个地方无法完成，请看看

UPDATE     [TT_InventoryTable-Parts] INNER JOIN
           TT_FinishedGoodsInventory ON [TT_InventoryTable-Parts].[Parts No] = TT_FinishedGoodsInventory.[Finished Goods No]
SET        [TT_InventoryTable-Parts].[Difference Rate] = --IIf(([Result Stocktaking Quantity] <> 0 AND [PRE-Stocktaking Quantity] <> 0 AND
           --[PRE-Stocktaking Quantity] <> [Result Stocktaking Quantity]), Format((([Result Stocktaking Quantity] / [PRE-Stocktaking Quantity]) - 1) * 100, [#,###.###]),0)
CASE WHEN ([Result Stocktaking Quantity] <> 0
AND    [PRE-Stocktaking Quantity] <> 0
AND        [PRE-Stocktaking Quantity] <> [Result Stocktaking Quantity])
THEN    replace(convert(varchar(20),(([Result Stocktaking Quantity] / [PRE-Stocktaking Quantity]) - 1) * 100,',','.')
ELSE    0

如何转换联接？