更新时不匹配两个表中的值

Question

我有两个没有匹配值的表表1

>td style="text-align:right；">AAA

Col1	Col2	Col3
101	111
102	222	BBB

您可以使用CROSS JOIN并在WHERE子句中相应地指定Col1值

UPDATE t2
SET    Col2 = t1.Col2,
Col3 = t1.Col3
FROM   Table2 AS t2
CROSS JOIN Table1 AS t1
WHERE  t2.Col1 = 103
AND    t1.Col1 = 101