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