proc team_member.sql

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

create procedure team_member
@team_id varchar(20)
as
select custom_type,custom_id,custom_name,custom_sex,custom_telephone,custom_room,r_style_name,room_combine,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 custom_team=@team_id