Posts by Nelson • 9 points

• 0

  votes

  2

  answers

  46

  views

  A: Query help for the problem created?

  Very logical. Simple. SELECT ec.*, ea.Estagio AS EstagioAtual, pe.Estagio As ProximoEstagio FROM EstagiosCronologia ec JOIN Estagios ea ON ea.EstagioId = ec.EstagioAtualId JOIN Estagios pe ON…

  sql asp.net-mvc query

  answered 4 years, 8 months ago Nelson 9

• 0

  votes

  2

  answers

  46

  views

  A: Query help for the problem created?

  I got the answer. SELECT e.Estagio AS Atual, (SELECT est.Estagio FROM EstagiosCronologia ecs INNER JOIN Estagios est ON ecs.ProximoEstagioId = est.EstagioId WHERE ecs.EstagioAtualId =…

  sql asp.net-mvc query

  answered 4 years, 9 months ago Nelson 9

• -1

  votes

  2

  answers

  46

  views

  Q: Query help for the problem created?

  I need to create a list composed by the fields Current and Next Stage both stage names coming from the same table. Example of the result I seek: Stage Table (stage name provider) The query searches…

  sql asp.net-mvc query

  asked 4 years, 9 months ago Nelson 9