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