Posts by Clayton • 11 points

• 1

  votes

  1

  answer

  1533

  views

  A: List sub-query table with main query

  SELECT Zona.nomeZona, ( SELECT SUM(qtdPessoas) AS ttPessoas FROM ( SELECT COUNT(DISTINCT Itinerario.codFuncionario) AS qtdPessoas, Itinerario.codZona1 FROM Itinerario GROUP BY Itinerario.codZona1…

  mysql query select-sql select sql-table

  answered 10 years, 7 months ago Clayton 11