SELECT
*
FROM
shoufeijl A
LEFT JOIN (
SELECT
BC.*
FROM
(
SELECT
max(id) AS fpid
FROM
ml_fapiao
GROUP BY
sfjlid
) AC
LEFT JOIN ml_fapiao BC ON AC.fpid = BC.id
) fp ON A.id = fp.sfjlid where A.yiyuanid=7
mysql:主从表一对多,取一条数据,从表id最大的
最新推荐文章于 2024-04-23 14:20:47 发布