创建场景设备视图vw_SceneDevice

创建视图vw_SceneDevice as select s.SceneID as 场景ID, dy.RoomName as 房间名称, s.SceneName as 场景名称, s.SceneDescription as 场景描述, s.UserID as 用户ID, d.DeviceName as 设备名称, ds.StatusName as 状态名称 from SceneDevice sd inner join Scene s on sd.StatusID = s.SceneID inner join Device d on d.DeviceID = s.SceneID inner join DeviceStatus ds on ds.StatusID = s.SceneID inner join Room dy on dy.RoomID = s.SceneID;