sql语句问题

Question

FROM & WHERE里面的是什么意思，请前辈给我上上课

   SELECT
    tg.game_id,
    tg.game_name_cn,
    tg.hot,
    tgfc.state 
FROM
    usercenter.t_game AS tg
    LEFT JOIN ( SELECT game_id, max( state ) AS state FROM usercenter.t_game_field_config GROUP BY game_id ) AS tgfc ON tg.game_id = tgfc.game_id 
WHERE
    company_id = 0
    

Answer 1

from: 表示要操作的表, 可以理解为数据源
where: 筛选数据的条件
参照文档: http://www.w3school.com.cn/sq...