oracle sql语句left join右表取最新的一条数据

SELECT
	*
FROM
	TABLE1 A
LEFT JOIN (
	SELECT
		*
	FROM
		(
			SELECT
				T .*, ROW_NUMBER () OVER (
					PARTITION BY T .PROBE_ID
					ORDER BY
						T .create_time DESC
				) rn
			FROM
				TABLE2 T
		) c
	WHERE
		rn = 1
) b ON A . ID = b.probe_id