[dbo].[ProcStatusJoinedView]
SET QUOTED_IDENTIFIER OFF
GO
create view ProcStatusJoinedView as SELECT ProcStatusListView.process_name, ProcStatusCompView.instance_count AS complete_count, ProcStatusIncompView.instance_count AS incomplete_count FROM (ProcStatusListView LEFT OUTER JOIN ProcStatusCompView ON ProcStatusListView.process_name = ProcStatusCompView.process_name) LEFT OUTER JOIN ProcStatusIncompView ON ProcStatusListView.process_name = ProcStatusIncompView.process_name
GO
GRANT SELECT ON [dbo].[ProcStatusJoinedView] TO [aionadmin_group]
GO
