Order By em subselect [Resolvido]

[apalmeiraParticipante]

Galera,

Assim funcionou:

Valeu pela força!


SELECT DISTINCT
P.ID AS PROC_ID,
P.NREF,

(
SELECT
F.INSERT_DATA
FROM
SIS.FOLLOWUP F
WHERE
F.ID = (SELECT MAX(ID) FROM SIS.FOLLOWUP T WHERE T.PROCESSO = P.NREF)
) AS FLP_DATA,

(
SELECT
F.ID
FROM
SIS.FOLLOWUP F
WHERE
F.ID = (SELECT MAX(ID) FROM SIS.FOLLOWUP T WHERE T.PROCESSO = P.NREF)
) AS FLP_ID,

(
SELECT
F.POSICAOFLP_ID
FROM
SIS.FOLLOWUP F
WHERE
F.ID = (SELECT MAX(ID) FROM SIS.FOLLOWUP T WHERE T.PROCESSO = P.NREF)
) AS POSICAOFLP_ID

FROM
SIS.ABREPROCESSO P