MySQL INNER JOIN Alias

Question

Does anyone know how I can do an inner joins and alias values within so they won t overwrite each other  It might look more clear if you see my code       SELECT  home  away  g network  g date start      FROM    game g     INNER JOIN team t ON            t importid   g home  as home         OR          t importid   g away  as away           ORDER BY date start DESC      LIMIT 7   SOLVED  After the help below here is my final query       SELECT          home market AS home market           away market AS away market           g network           g date start      FROM game AS g     INNER JOIN team AS home ON           home importid   g home           INNER JOIN team AS away ON           away importid   g away            ORDER BY g date start DESC      LIMIT 7

User · Accepted Answer

You ll need to join twice   SELECT home    away    g network  g date start  FROM game AS g INNER JOIN team AS home   ON home importid   g home INNER JOIN team AS away   ON away importid   g away ORDER BY g date start DESC  LIMIT 7

User · Answer

Use a seperate column to indicate the join condition  SELECT  t importid           case              when t importid   g home              then  home               else  away           end as join condition           g network           g date start  FROM    game g INNER JOIN team t ON  t importid   g home OR t importid   g away  ORDER BY date start DESC  LIMIT 7

[mysql] MySQL INNER JOIN Alias

Examples related to mysql

Examples related to select