三表联合查询

MySQL 数据库，三表联合查询：

SELECT     f.*,s.*,p.*

FROM sign s INNER JOIN fee f on s.sign_contract_code = f.sign_contract_code INNER JOIN pricing p ON f.id = p.id;

where f.id =100