sql查询并把数据更新到另一个表中

update OpenBills  set peopleCount=(select rtNumber from Rooms where obId='ZD201005223') where obId='ZD201005223'