sql查询并把数据更新到另一个表中
update OpenBills set peopleCount=(select rtNumber from Rooms where obId='ZD201005223') where obId='ZD201005223'
交流扣扣:1328542512
update OpenBills set peopleCount=(select rtNumber from Rooms where obId='ZD201005223') where obId='ZD201005223'