Advertisement
Guest User

Untitled

a guest
Aug 24th, 2019
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. -- Resposta C
  2.  
  3. SELECT UF.sigla_uf UF,
  4. DEP.dptonome,
  5. EMP.matricula ,
  6. EMP.ename nome_empregado,
  7. EMP.cargo,
  8. EMP.data_contratacao,
  9. EMP.salario
  10. FROM EMPREGADO EMP
  11. INNER JOIN DEPARTAMENTO DEP
  12. ON EMP.DEPTONO = DEP.DEPTONO
  13. INNER JOIN UF
  14. ON DEP.UF_UFNO = UF.UFNO
  15. ORDER BY UF, DPTONOME, nome_empregado
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement