query_client_live_state.sql

一套宾馆管理系统

select custom_name,b.Sex_name,c.Country_name,a.custom_birth,
       a.custom_phone,a.custom_address,a.custom_idno,
       a.regist_date,d.room_no,d.flooer_id,a.bed_no,e.bedSta_name,
       a.bedsta_id,f.roompro_name
  from CustomerList a left outer join SexList b
       on a.custom_sexid=b.Sex_id
       left outer join CountryList c
       on a.custom_countryid=c.Country_id
       left outer join RoomList d
       on a.room_id=d.room_id 
       left outer join Bedstatus e
       on a.bedsta_id=e.BedSta_id
       left outer join RoomProperty f
       on d.roompro_id =f.Roompro_id
 where regist_id=1
--ClientID