ApellidosEmpleadosVendedores.sql

SELECT P1.LastName AS 'Apellido'
    FROM HumanResources.Employee AS E
        INNER JOIN Person.Person AS P1
            ON e.BusinessEntityID = P1.BusinessEntityID
UNION
SELECT P2.LastName AS 'Apellido'
    FROM Sales.SalesPerson AS SP
        INNER JOIN Person.Person AS P2
            ON SP.BusinessEntityID = P2.BusinessEntityID;