Posts by Vitor Morais • 21 points

• 2

  votes

  2

  answers

  55

  views

  Q: Why do if or case tests not work in this subquery?

  I am trying to run the following subquery within a view: (SELECT if(idnotas > 0, "não", "sim") FROM notas WHERE vendas_idvendas = p.vendas_idvendas ORDER BY idnotas DESC LIMIT 1 ) as…

  mysql query if case

  asked 5 years, 10 months ago Vitor Morais 21