如何用B表中的数据更新A表

 编写下述语句:
UPDATE A SET (S,D)=
       (SELECT S,D FROM B WHERE A.A_ID = B.B_ID);

实际业务：

UPDATE obr_temreg_info_out a SET (REGORG_NAME,REGORG_CODE)=
       (SELECT organ_cn_name,organ_info_id FROM rfo_organ_info_out WHERE a.send_organ_code = b.organ_info_id)  where REGORG_NAME is null or REGORG_CODE is null;