如果您正在使用cte，请尝试以下操作：

WITH select_last_tourn AS (
                SELECT fc.ID as FC_ID,fc.IDENTIFIANT, mnt.ID as TOUR_ID, mnt.DATE_TOURNEE,
                max (mnt.DATE_TOURNEE) OVER (ORDER BY mnt.DATE_TOURNEE) DT_LAST_TOURNEE
                FROM RSF_FICHE_11 fc
                lEFT JOIN mnt ON fc.ID=mnt.ID1
                           )

SELECT * FROM select_last_tourn

听了你的话，我做了新的测试。没有成功，我把剩下的请求。

WITH mnt AS (
select cast(mt.ID as numeric) as ID, cast(mt.ID1 as numeric) as ID1,
format_date(t.DATE_TOURNEE,'dd/MM/yyyy') as DATE_TOURNEE  
FROM MR_P mt 
LEFT JOIN RF_TOURNEE t ON mt.ID=t.ID
)
SELECT fc.ID as FC_ID,fc.IDENTIFIANT, mnt.ID as TOUR_ID, mnt.DATE_TOURNEE,max (mnt.DATE_TOURNEE) OVER (ORDER BY mnt.DATE_TOURNEE) DT_LAST_TOURNEE
FROM RF_Fiches fc 
LEFT JOIN mnt ON fc.ID=mnt.ID1;

错误sql