Doubt ORDER BY with INNER JOIN

0

Hi, I want to generate a classification of some equipment but I do not know how to do it so that they come out in a specified order, I do not know how to enter the ORDER BY.

SELECT 

    divisiones.id_eq1 AS Equipo_1,
    eq1.name_eq AS Nombre_E1,
    divisiones.id_eq2 AS Equipo_2, 
    eq2.name_eq AS Nombre_E2,
    divisiones.id_eq3 AS Equipo_3, 
    eq3.name_eq AS Nombre_E3,
    divisiones.id_eq4 AS Equipo_4, 
    eq4.name_eq AS Nombre_E4,
    divisiones.id_eq5 AS Equipo_5, 
    eq5.name_eq AS Nombre_E5,
    divisiones.id_eq6 AS Equipo_6, 
    eq6.name_eq AS Nombre_E6,
    divisiones.id_eq7 AS Equipo_7, 
    eq7.name_eq AS Nombre_E7,
    divisiones.id_eq8 AS Equipo_8, 
    eq8.name_eq AS Nombre_E8,
    divisiones.id_eq9 AS Equipo_9,
    eq9.name_eq AS Nombre_E9,
    divisiones.id_eq10 AS Equipo_10,
    eq10.name_eq AS Nombre_E10,
    divisiones.id_eq11 AS Equipo_11,
    eq11.name_eq AS Nombre_E11,
    divisiones.id_eq12 AS Equipo_12,
    eq12.name_eq AS Nombre_E12    

FROM divisiones

  INNER JOIN equipos AS eq1
  ON divisiones.id_eq1 = eq1.id_eq
  INNER JOIN equipos AS eq2
  ON divisiones.id_eq2 = eq2.id_eq
  INNER JOIN equipos AS eq3
  ON divisiones.id_eq3 = eq3.id_eq
  INNER JOIN equipos AS eq4
  ON divisiones.id_eq4 = eq4.id_eq
  INNER JOIN equipos AS eq5
  ON divisiones.id_eq5 = eq5.id_eq
  INNER JOIN equipos AS eq6
  ON divisiones.id_eq6 = eq6.id_eq
  INNER JOIN equipos AS eq7
  ON divisiones.id_eq7 = eq7.id_eq
  INNER JOIN equipos AS eq8
  ON divisiones.id_eq8 = eq8.id_eq
  INNER JOIN equipos AS eq9
  ON divisiones.id_eq9 = eq9.id_eq
  INNER JOIN equipos AS eq10
  ON divisiones.id_eq10 = eq10.id_eq
  INNER JOIN equipos AS eq11
  ON divisiones.id_eq11 = eq11.id_eq
  INNER JOIN equipos AS eq12
  ON divisiones.id_eq12 = eq12.id_eq

WHERE division_name = '$_POST[createDiv]';
    
asked by Alvaro Ruiz 06.06.2018 в 11:39
source

0 answers