Skip to content

Instantly share code, notes, and snippets.

@mvnp

mvnp/SQL

Created August 23, 2017 01:39
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mvnp/84ea6252e67d37596d4a8b031bf1201d to your computer and use it in GitHub Desktop.
Save mvnp/84ea6252e67d37596d4a8b031bf1201d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
SQL
SELECT f.FUNC_NOME, p.PERG_PERG, r.RSPND_RESP_AVALO, e.PDOS_AVALR_ID,
(SELECT f.FUNC_NOME FROM funcionarios f WHERE f.ID = e.PDOS_AVALR_ID) AS NOME_AVALIADOR
FROM responder r
INNER JOIN perguntas p on r.RSPND_PERG_ID = p.ID
INNER JOIN funcionarios f on r.RSPND_AVALO_ID = f.ID
INNER JOIN pesquisados e on r.RSPND_PESQ_ID = e.ID
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment