CREATE view  View_Request_to_Act_Log AS SELECT View_Request.*, View_Act_Log.id actlog_id, View_Act_Log.persid actlog_persid, View_Act_Log.call_req_id, View_Act_Log.last_mod_dt actlog_last_mod_dt, View_Act_Log.time_spent, View_Act_Log.time_stamp, View_Act_Log.system_time, View_Act_Log.analyst, View_Act_Log.description actlog_desc, View_Act_Log.action_desc, View_Act_Log.type actlog_type, View_Act_Log.knowledge_session, View_Act_Log.knowledge_tool, View_Act_Log.internal, View_Act_Log.activity_type, View_Act_Log.analyst_lastname, View_Act_Log.analyst_firstname, View_Act_Log.analyst_middlename FROM ( View_Request inner join  View_Act_Log ON View_Request.persid = View_Act_Log.call_req_id)
GO
GRANT SELECT ON  [dbo].[View_Request_to_Act_Log] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[View_Request_to_Act_Log] TO [service_desk_ro_group]
GO