View: dbo.Privilege_Dependency_View | |||
View definition | |||
create view dbo.Privilege_Dependency_View as select privilege_dependency_KEY = PD.privilege_dependency_KEY , privilege_KEY = PD.privilege_KEY , privilege__description = P.description , privilege__parent__privilege_KEY = P.parent__privilege_KEY , dependent__privilege_KEY = PD.dependent__privilege_KEY , dependent__privilege__description = P1.description , dependent__privilege__parent__privilege_KEY = P1.parent__privilege_KEY from dbo.Privilege_Dependency PD left outer join dbo.Privilege P on P.privilege_KEY = PD.privilege_KEY left outer join dbo.Privilege P1 on P1.privilege_KEY = PD.dependent__privilege_KEY | |||