view custom_room_infor.sql

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

create procedure checkout_team_member
@team_name varchar(20)
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_team,team_name,custom_explain
from room_infor,custom_infor,r_style_infor,team_infor
where r_style_id=room_style and custom_room=room_id and custom_team=team_id and team_name=@team_name