ALL_MANAGERS_BY_SITE

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   ALL_MANAGERS_BY_SITE

Name
EMP_FNAME
EMP_ID
EMP_LNAME
NAME
PHONE
SITENAME
STATUS

CREATE VIEW ALL_Managers_by_Site(emp_id, emp_lname, emp_fname, phone,status,SiteName)
	AS SELECT 
			employee.emp_id,
			employee.emp_fname,
			employee.emp_lname,
			employee.phone,
			employee.status,
      S.Name
		FROM
			EMPLOYEE employee
    INNER JOIN ALL_Sites  S ON S.Manager_Id = employee.EMP_ID

Name	Types	Description
DERIVEDTABLE	Table	Table
<DEFAULT SCHEMA>.EMPLOYEE	Table	Table
<DEFAULT SCHEMA>.ALL_SITES	View	View
<DEFAULT SCHEMA>.EMPLOYEE.EMP_FNAME	Column	Column
<DEFAULT SCHEMA>.EMPLOYEE.EMP_LNAME	Column	Column
<DEFAULT SCHEMA>.ALL_SITES.MANAGER_ID	Column	View column
<DEFAULT SCHEMA>.ALL_SITES.NAME	Column	View column
PHONE	Column	Virtual column
STATUS	Column	Virtual column
<DEFAULT SCHEMA>.EMPLOYEE.EMP_ID	Primary Key	Column

Name	Types	Description
<DEFAULT SCHEMA>.ALL_MANAGERS	View	View
<DEFAULT SCHEMA>.ALL_MANAGERS.Select	Select Statement	SELECT AMD.emp_id, AMD.emp_fname, AMD.emp_lname, AMD.phone,