update OpenBills set peopleCount=(select rtNumber from Rooms where obId='ZD201005223') where obId='ZD201005223'
update OpenBills set peopleCount=(select rtNumber from Rooms where obId='ZD201005223') where obId='ZD201005223'
转载于:https://www.cnblogs.com/codeDevotee/p/7257051.html