update的语句怎样写?
a
Sales FirstName LastName Author
----------- ------ ---------
22246 Anne Ringer
22246 Michel DeFrance
18722 Marjorie Green
b
Sales Author
----------- -----------------
22246 Anne Ringer
22246 Michel DeFrance
18722 Marjorie Green
用b表Authot列的数据更新a表author列的数据
结果是
Sales FirstName LastName Author
----------- ------ --------- --------
22246 Anne Ringer Anne Ringer
22246 Michel DeFrance Michel DeFrance
18722 Marjorie Green Marjorie Green
update的语句怎样写?