当oracle中的一个连接字段是多对1时，当连接3个表时，我如何根据最大日期获得准确的计数？

SELECT t1.field1, t2.field2, t3.field3
FROM table1 t1
JOIN table2 t2 ON t1.join_field = t2.join_field
JOIN table3 t3 ON t2.join_field = t3.join_field;

SELECT t1.field1, MAX(t2.date_field) AS max_date
FROM table1 t1
JOIN table2 t2 ON t1.join_field = t2.join_field
JOIN table3 t3 ON t2.join_field = t3.join_field
GROUP BY t1.field1;

SELECT t1.field1, t2.field2, t3.field3, subquery.max_date, COUNT(*) AS count
FROM table1 t1
JOIN table2 t2 ON t1.join_field = t2.join_field
JOIN table3 t3 ON t2.join_field = t3.join_field
JOIN (
    SELECT t1.field1, MAX(t2.date_field) AS max_date
    FROM table1 t1
    JOIN table2 t2 ON t1.join_field = t2.join_field
    JOIN table3 t3 ON t2.join_field = t3.join_field
    GROUP BY t1.field1
) subquery ON t1.field1 = subquery.field1 AND t2.date_field = subquery.max_date
GROUP BY t1.field1, t2.field2, t3.field3, subquery.max_date;