CREATE view  View_Change_to_Request AS SELECT View_Change.*, call_req.id cr_id, call_req.ref_num, call_req.summary cr_summary, call_req.persid cr_persid, call_req.description cr_description, call_req.status cr_status, call_req.active_flag cr_active_flag, call_req.time_spent_sum, call_req.open_date cr_open_date, call_req.last_mod_dt cr_last_mod_dt, call_req.close_date cr_close_date, call_req.log_agent cr_log_agent, call_req.group_id cr_group_id, call_req.assignee cr_assignee,call_req.customer, call_req.charge_back_id, call_req.affected_rc, call_req.support_lev cr_support_lev, call_req.category cr_category, call_req.solution, call_req.impact cr_impact, call_req.priority cr_priority, call_req.urgency, call_req.severity, call_req.extern_ref, call_req.last_act_id, call_req.cr_tticket, call_req.parent cr_parent, call_req.template_name cr_template_name, call_req.sla_violation cr_sla_violation, call_req.predicted_sla_viol cr_predicted_sla_viol, call_req.created_via cr_created_via, call_req.call_back_date cr_call_back_date, call_req.call_back_flag cr_call_back_flag, call_req.event_token, call_req.type, call_req.string1 cr_string1, call_req.string2 cr_string2, call_req.string3 cr_string3, call_req.string4 cr_string4, call_req.string5 cr_string5, call_req.string6 cr_string6, call_req.change FROM ( View_Change inner join  call_req ON View_Change.id = call_req.change)
GO
GRANT SELECT ON  [dbo].[View_Change_to_Request] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[View_Change_to_Request] TO [service_desk_ro_group]
GO