View: dbo.Recorded_Event_View | |||
View definition | |||
create view dbo.Recorded_Event_View as select create_date = RE.create_date , computer = RE.computer , client_KEY = REONC.client_KEY , event_type_KEY = RE.event_type_KEY , event_class_type_KEY = RE.event_class_type_KEY , details = coalesce(RE.details, N'') , alert_level_KEY = RE.alert_level_KEY , is_system_event = RE.is_system_event , update__staff_KEY = RE.update__staff_KEY , text = coalesce(RE.text, N'') , recorded_event_KEY = RE.recorded_event_KEY from dbo.Recorded_Event RE left join dbo.Recorded_Event_Client_Recorded_Event_Object RECREO on RECREO.recorded_event_KEY = RE.recorded_event_KEY left join dbo.Recorded_Event_Object REO on REO.recorded_event_object_KEY = RECREO.recorded_event_object_KEY left join dbo.Recorded_Event_Object_N_Client REONC on REONC.recorded_event_object_KEY = REO.recorded_event_object_KEY | |||