Hi.

I have this Query:

SELECT
MAX("Treatments"."WorkStartDate") "WorkStartDate",
MAX("TreatmentDetails"."TreatmentDetailDate") "TreatmentDetailDate"
FROM
"Treatments" LEFT OUTER JOIN "TreatmentDetails"
ON "Treatments"."TreatmentID" = "TreatmentDetails"."TreatmentID"

Is there away to get the bigger Date of those two fields in one fields and not I two as I did ?

Best Regards.
Yossi


[Non-text portions of this message have been removed]