GET_LOG_2017_BY_MANAGERS

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   GET_LOG_2017_BY_MANAGERS

Name
ACTION
EMP_FNAME
EMP_LNAME
EMPLOYEE_ID
LOG_DATE
MESSAGE
STATUS
TITLE

CREATE VIEW Get_Log_2017_By_Managers (Log_date, Action, Title, Message, Employee_Id,EMP_FNAME,EMP_LNAME,STATUS) 
AS SELECT 
      Log_date,
      Action, 
      Title,
      Message,
      Employee_Id,
      EMP_FNAME,
      EMP_LNAME,
      STATUS
		FROM
			Get_Log_2017 log
    
    INNER JOIN ALL_Managers  e ON E.Id = log.Employee_Id

Name	Types	Description
DERIVEDTABLE	Table	Table
<DEFAULT SCHEMA>.ALL_MANAGERS	View	View
<DEFAULT SCHEMA>.GET_LOG_2017	View	View
<DEFAULT SCHEMA>.GET_LOG_2017.EMPLOYEE_ID	Column	View column
<DEFAULT SCHEMA>.ALL_MANAGERS.ID	Column	View column