Вывод зависимостей выбранного пакета в виде таблицы

/*
Вывести зависимость выбранного пакета от других пакетов
*/
SELECT DependingPackage.Name AS 'Пакет', DependedPackage.Name AS 'Зависит от пакетов' FROM SysPackageDependency
INNER JOIN SysPackage AS DependedPackage ON DependedPackage.Id = SysPackageDependency.DependOnPackageId
INNER JOIN SysPackage AS DependingPackage ON DependingPackage.Id = SysPackageDependency.SysPackageId
WHERE SysPackageId =
(
SELECT id FROM SysPackage WHERE Name = 'Custom' --введите название пакета
)
ORDER BY DependedPackage.Name

/*
Вывести зависимые пакеты от указанного пакета
*/
SELECT DependedPackage.Name AS 'Пакет', DependingPackage.Name AS 'Зависимые пакеты' FROM SysPackageDependency
INNER JOIN SysPackage AS DependedPackage ON DependedPackage.Id = SysPackageDependency.DependOnPackageId
INNER JOIN SysPackage AS DependingPackage ON DependingPackage.Id = SysPackageDependency.SysPackageId
WHERE DependOnPackageId =
(
SELECT id FROM SysPackage WHERE Name = 'Base' --введите название пакета
)
ORDER BY DependingPackage.Name