Posts by Guilherme • 11 points

• -1

  votes

  2

  answers

  65

  views

  A: Two Results in a Query

  SELECT A.SETORID, SETOR, VAGAS, B.NOME FROM SETOR A INNER JOIN FUNCIONARIOS B ON A.SETORID=B.SETORID WHERE A.SETORID = XXX This way you join the two tables by SETORID and bring the information you…

  sql

  answered 7 years, 11 months ago Guilherme 11