select_setsomelive.sql

一套宾馆管理系统

update CustomerList
set CustomerList.room_id=b.room_id,CustomerList.bedsta_id=c.bedsta_id
from  roomlist b,bedStatus c
where Regist_id=Client_id 
and b.room_no='102'
and c.bedsta_name='使用'