SELECT [Student].[id_student] AS [id_student], [Student].[Sutfname] AS [Sutfname], [Student].[Sutname] AS [Sutname], [Student].[Stipend] AS [Stipend], [Student].[Kurs] AS [Kurs], [Student].[City] AS [City], [Student].[Birtday] AS [Birtday], [Student].[Group] AS [Group], [Student].[Kod_kafedru] AS [Kod_kafedru] FROM [dbo].[Student] AS [Student] SELECT [Teacher].[Kod_teacher] AS [Kod_teacher], [Teacher].[Kod_kafedru] AS [Kod_kafedru], [Teacher].[Name_teacher] AS [Name_teacher], [Teacher].[Surname_teacher] AS [Surname_teacher], [Teacher].[Patronymic_teacher] AS [Patronymic_teacher], [Teacher].[idenf_kod] AS [idenf_kod], [Teacher].[dolgnost] AS [dolgnost], [Teacher].[zvanie] AS [zvanie], [Teacher].[salary] AS [salary], [Teacher].[rise] AS [rise], [Teacher].[data_hire] AS [data_hire], [Teacher].[birdhdate] AS [birdhdate], [Teacher].[pol] AS [pol], [Teacher].[tel_teacher] AS [tel_teacher] FROM [dbo].[Teacher] AS [Teacher]