---

USE [X-SKUD];

SELECT TOP 20
    p.TabNum AS [Табельный номер],
    p.FName AS [Фамилия],
    p.Name AS [Имя],
    e.TimeEv AS [Время события],
    e.EventCode AS [Код события],
    e.EventRemark AS [Описание]
FROM dbo.pEvents e
LEFT JOIN dbo.pList p ON e.HozOrgan = p.ID
ORDER BY e.TimeEv DESC;