DROP VIEW IF EXISTS `вирт_Кафедра`;
CREATE VIEW `вирт_Кафедра` AS
SELECT
``.`` AS `Код кафедры`,
``.`` AS `Название кафедры`,
``.`` AS `Код факультета`,
``.`` AS `Название факультета`,
``.`` AS `Ид\Кафедра`
FROM `` AS ``
LEFT JOIN `` AS `` ON ``.`` = ``.``
;
SELECT * FROM `вирт_Кафедра`;