mysql join取别名,MySQL INNER JOIN别名

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

解决方案

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