---

SELECT TOP 20
    pl.ID AS [ID сотрудника],
    pl.Code AS [Код / Табельный],
    pl.Name AS [Фамилия],
    pl.FirstName AS [Имя],
    pl.MidName AS [Отчество],
    pld.TimeVal AS [Время прохода],
    ap.Name AS [Точка доступа / Дверь]
FROM [X-SKUD].dbo.pLogData pld
LEFT JOIN [X-SKUD].dbo.pList pl ON pl.ID = pld.HozOrgan
LEFT JOIN [X-SKUD].dbo.AcessPoint ap ON ap.GIndex = pld.DoorIndex
WHERE pl.ID IS NOT NULL
ORDER BY pld.TimeVal DESC;