mysql 多表连接查询

select media_name.name,media_hot.hot from  media_name inner join media_hot on media_hot.id=media_name.id order by hot desc

根据media_hot表中id,hot项的Hot倒序输出media_name的name及hot