view book_available.sql

来自「人员管理客房管理结算客房预定人员权限管理等等」· SQL 代码 · 共 8 行

create view book_available(room_floor,room_id,r_style_name,room_available,room_used,room_combine,r_style_price,r_style_conprice,r_style_discount,room_state,room_explain)
as 
select room_floor,room_id,r_style_name,room_available,room_used,room_combine,r_style_price,r_style_conprice,r_style_discount,room_state,room_explain
from room_infor,r_style_infor
where room_state='空房'and room_booked=0 and r_style_id=room_style