问一个多表查询的简单问题？-灵析社区

先查询出procheck表里每个产品对应最新的checkdate，再拿你的结果连接一下作筛选 (你的SQL语句) t1 JOIN ( SELECT pro_id, MAX(checkdate) AS max_checkdate FROM procheck GROUP BY pro_id ) t2 ON t1.procheck__pro_id = t2.pro_id AND t1.procheck__checkdate = t2.max_checkdate;