Q:

How to create a VIEW by join multiple tables having multiple columns using SQL Server

I am creating a view for a table and joining multiple tables for additional columns, getting exact output for some join tables which has only two columns(ID, Name) in it. But i am getting 'Ambiguous column error' for a column which i am using  one join table which has more than 10 columns in it.
I know why I am getting this error but i need help to call the EventName from EventInfo join table. Also is it possible to give different column names in the view.
Below are the select statement and the join table that I am getting error. 
Thanks in advance for your suggestions.
SELECT 
    Event_ID, EventName 
FROM 
    [dbo].[tbl_ValueTool_Event_ResultantDataEntryData] Res_event      
JOIN 
    [GRID_ProjectServer_Applications].[dbo].[tbl_ValueTool_EventInformation] EVT ON Res_event.[Event_ID] = EVT.[Event_ID]

Below is the join table from which I want to call the column names corresponding to the Id's

A:

You can use alias for the column names if needed.
SELECT EVT.Event_ID, EVT.EventName 
FROM [dbo].[tbl_ValueTool_Event_ResultantDataEntryData] Res_event 
JOIN [GRID_ProjectServer_Applications].[dbo].[tbl_ValueTool_Event‌​Information] EVT 
ON Res_event.[Event_ID] = EVT.[Event_ID]

