从一个表列到另一个表列的SQL值

Question

我有一个简单的select语句来标识我要更新的行。基本上，我想将vad_description复制到vb_description中，但无法完全弄清楚这一点。任何帮助都将不胜感激。

    SELECT
  variant_bom.vb_id
 ,variant_bom.vb_description
 ,variant_detail.vad_description
FROM dbo.variant_bom
INNER JOIN dbo.variant_detail
  ON variant_bom.vb_vad_id = variant_detail.vad_id
INNER JOIN dbo.variant_setting
  ON variant_setting.vas_vad_id = variant_detail.vad_id
WHERE variant_setting.vas_manufactured_variant = 1
AND variant_setting.vas_discontinued_product = 0

Answer 1

试试像这样的东西

UPDATE vb
SET    vb.vb_description = vd.vad_description
FROM   dbo.variant_bom vb
       INNER JOIN dbo.variant_detail vd
               ON vb.vb_vad_id = vd.vad_id
       INNER JOIN dbo.variant_setting vs
               ON vs.vas_vad_id = vd.vad_id
WHERE  vs.vas_manufactured_variant = 1
       AND vs.vas_discontinued_product = 0 

为表提供Alias名称将使查询更加可读性