view book_custom_infor.sql

人员管理客房管理结算客房预定人员权限管理等等

create view book_custom_infor
as 
select custom_type,custom_id,custom_name,custom_sex,custom_telephone,custom_room,r_style_name,room_combine,r_style_price,r_style_conprice,r_style_discount,custom_intime,custom_outtime,custom_used,custom_deposit,custom_explain
from custom_infor,room_infor,r_style_infor
where custom_room=room_id and custom_team='0' and custom_state='2'and room_style=r_style_id