MySQL INNER JOIN Alias

mysql, select

Solution

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

Problem

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 ```

Original source