UPDATe [Sale_Goods] SET [Catalog33_ID] = [Catalog].[ID]
FROM [Sale_Goods]
LEFT OUTER JOIN [chdy222] ON [Sale_Goods].[Code] = [chdy222].[ID]
LEFT OUTER JOIN [Catalog] ON [chdy222].[ufidaname] = [Catalog].[Name] and [Catalog].[Type]=33
WHERE [Catalog].[ID] IS NOT NULL
SQL应用日志
最新推荐文章于 2022-11-30 06:33:23 发布