求SQL COMMAND -有關UPDATE DATA

Question

tb1 - EntryID, CustNo, CustName
tb2 - EntryID, CustNo, Amountselect * 
from tb1 inner join tb2 on tb1.EntryID=tb2.EntryIDEntryID CustNo CustName EntryID CustNo Amount
1 NULL APPLE CO 1 A0001 10.00 
2 NULL BANANA CO 2 B0001 20.00 
3 NULL ORANGE CO 3 O0001 30.00 現想將tb2之CustNo 拷貝至tb1的custno, 求sql command

Answer 1

UPDATE tb1 SET CustNo=tb2.CustNo from tb1 inner join tb2 on tb1.EntryID=tb2.EntryID

Answer 2

THANKS ,我做到啦, 多謝晒