
vw_Room_RoomType
SELECT dbo.Room.RoomID, dbo.Room.Number, dbo.Room.TypeID, 
      dbo.RoomType.TypeID AS Tid, dbo.RoomType.TypeName AS Tname, 
      dbo.Room.BedNumber, dbo.Room.Description, dbo.Room.State, 
      dbo.Room.GuestNumber, dbo.RoomType.TypePrice AS TPrice, 
      dbo.RoomType.AddBedPrice, dbo.RoomType.IsAddBed
FROM dbo.Room INNER JOIN
      dbo.RoomType ON dbo.Room.TypeID = dbo.RoomType.TypeID
      
vw_Guest_GuestCategory_Room
SELECT dbo.Guest.GuestID, dbo.Guest.Name, dbo.Guest.CategoryID, 
      dbo.GuestCategory.CategoryID AS Cid, dbo.GuestCategory.CategoryName AS Cname, 
      dbo.Guest.Sex, dbo.Guest.Mobile, dbo.Guest.RoomID, dbo.Room.RoomID AS Rid, 
      dbo.Guest.ArriveTime, dbo.Guest.LeaveTime
FROM dbo.Guest INNER JOIN
      dbo.GuestCategory ON 
      dbo.Guest.CategoryID = dbo.GuestCategory.CategoryID INNER JOIN
      dbo.Room ON dbo.Guest.RoomID = dbo.Room.RoomID