MySQL 多表关联一对多查询实现取最新一条数据的方法示例

SELECT
    cr.id,
    cr.real_name,
    oi.industry,
    oi.nature_tax
FROM
    customer AS cr
LEFT JOIN (
    slect fowlloname,fowlloid from (select follow_name as fowlloname,fowlloi_d  as fowlloid  from fowll_info fl where 1=1 order by

fl .follow_name  desc) a group by fowlloid  )as tome
    ) AS oi ON oi.customer_id = cr.id;