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

被折叠的 条评论
为什么被折叠?



