SQL 通过查询得出每个ID对应的数值怎么一次性更新上去？

[qq_30890773]

select a.CARD_NO,count(b.STOCK_QTY) as STOCK_QTY from MES_YX_RECEIPT_LIST a
inner join MES_YX_RL_STOCK b on a.RECEIPT_LIST_ID=b.RECEIPT_LIST_ID where isnull(CARD_NO,'')!=''
group by CARD_NO
这条语句查询出来的结果是每个ID对应一个数值

update MES_PP_PROC_CARD set NUM=？？ where CARD_NO=？？
select * from MES_YX_RL_STOCK
然后我想通过上面查询出来的结果，一次性的更新另一张表，而不是每次都是手动复制条件到CARD_NO中

存储过程怎么写？

[二月十六]

UPDATE MES_PP_PROC_CARD
SET NUM = t.一个值
FROM
(SELECT * FROM MES_YX_RL_STOCK) t
WHERE CARD_NO = t.关联值;

[qq_30890773]

update MES_PP_PROC_CARD set NUM=a.STOCK_QTY from (select a.CARD_NO,count(b.STOCK_QTY) as STOCK_QTY from MES_YX_RECEIPT_LIST a
inner join MES_YX_RL_STOCK b on a.RECEIPT_LIST_ID=b.RECEIPT_LIST_ID where isnull(CARD_NO,'')!=''
group by CARD_NO) a
这样写不知道可不可以？我不敢测试

[二月十六]

引用 2 楼 qq_30890773 的回复:

update MES_PP_PROC_CARD set NUM=a.STOCK_QTY from (select a.CARD_NO,count(b.STOCK_QTY) as STOCK_QTY from MES_YX_RECEIPT_LIST a inner join MES_YX_RL_STOCK b on a.RECEIPT_LIST_ID=b.RECEIPT_LIST_ID where isnull(CARD_NO,'')!='' group by CARD_NO) a 这样写不知道可不可以？我不敢测试

做好数据备份

[qq_30890773]

结贴了，可以了，谢谢