Posts by Dalton Kolln • 3 points

• 0

  votes

  1

  answer

  410

  views

  Q: Mysql, use SUM(total) > 10 quantity in WHERE

  I have the following MYSQL query: SELECT SUM(A.val) AS totalvendas, B.cod AS codigo, B.nom AS Nome, B.reg AS regiao FROM venda AS A LEFT JOIN vendedor AS B ON A.ven = B.cod WHERE reg = "norte" GROUP…

  mysql select where

  asked 7 years, 6 months ago Dalton Kolln 3