Posts by Luis • 36 points

• 2

  votes

  2

  answers

  18011

  views

  A: INNER JOIN with two fields of the same table

  You need to do 2 joins, one for source and one for destination. SELECT un_src.nome_unidade as origem, un_dst.nome_unidade as destino, FROM pedidos INNER JOIN unidades as un_src ON un_src.cod_unidade…

  mysql sql

  answered 9 years, 10 months ago Luis 36