Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Resposta C
- SELECT UF.sigla_uf UF,
- DEP.dptonome,
- EMP.matricula ,
- EMP.ename nome_empregado,
- EMP.cargo,
- EMP.data_contratacao,
- EMP.salario
- FROM EMPREGADO EMP
- INNER JOIN DEPARTAMENTO DEP
- ON EMP.DEPTONO = DEP.DEPTONO
- INNER JOIN UF
- ON DEP.UF_UFNO = UF.UFNO
- ORDER BY UF, DPTONOME, nome_empregado
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement