update OpenBills set peopleCount=(select rtNumber from Rooms where obId=‘ZD201005223‘) where obId=‘ZD201005223‘
sql查询并把数据更新到另一个表中
原文：http://www.cnblogs.com/codeDevotee/p/7257051.html
