SELECT 
Request.id, 
u2.Name AS Пользователь, 
Type_tb.TypeName AS Тип, 
Request.Comment AS Комментарий, 
Priority.PriorityName AS Приоритет, 
Status_tb.StatusName AS Статус, 
u1.Name AS Специалист, 
Request.Room AS Кабинет, 
Request.Phone AS Телефон 
FROM Request 
cross apply (Select top 1 * From Req_mov Where Req_mov.id = Request.id /*Order by  [Добавит критерий последнего и раскомментировать] */) Req_mov
INNER JOIN Priority ON Req_mov.id_priority = Priority.id_priority 
INNER JOIN Status_tb ON Req_mov.id_status = Status_tb.id_status 
INNER JOIN Type_tb ON Req_mov.id_type = Type_tb.id_type 
INNER JOIN Users AS u1 ON Req_mov.id_spec = u1.id_user 
INNER JOIN Users AS u2 ON Request.id_user = u2.id_user 
WHERE u1.Name = '" +Program.UserInfo.UserName+ "'"