SELECT C.NOMECARGO, F.NOMEFUNCIONARIO
FROM CARGO AS C
LEFT JOIN FUNCIONARIO AS F
ON C.IDCARGO = F.IDCARGO


SELECT C.NOMECARGO, F.NOMEFUNCIONARIO
FROM CARGO AS C
LEFT JOIN FUNCIONARIO AS F
ON F.IDCARGO = C.IDCARGO