SQL-使用来自3个表内部联接的另一个表的列中的数据设置列 [英] SQL - Set column with data from another table's column with 3 table inner join

问题描述

所以我无法使该SQL语句运行

因此，表A通过ID连接到表C，并且该ID通过ID连接到表C
我需要从表C获取UPC列数据，其中表A ID =表C ID

So I can''t get this SQL statement to run

So Table A is connected to table C through the ID and that ID is connected to Table C through ID
I need to get a UPC column Data from table C where table A ID = table C ID

UPDATE A
SET A.ID = [C].[UPC];
INNER JOIN TABLEB ON  A.ID = B.ID
INNER JOIN C ON B.ID = C.ID

推荐答案

如果您使用的是SQL Server，则(T-SQL)

If you are using SQL Server then (T-SQL)

UPDATE A
SET ID = [C].[UPC]
FROM A 
INNER JOIN B ON  A.ID = B.ID
INNER JOIN C ON B.ID = C.ID

否则，我将无法使用T-SQL而不是SQL.

else I can not help you as I use T-SQL not SQL.

UPDATE A
SET A.UPC = [C].[UPC]
From A
INNER JOIN B ON  A.ID = B.ID
INNER JOIN C ON B.ID = C.ID

这篇关于SQL-使用来自3个表内部联接的另一个表的列中的数据设置列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！