hola amigos estoy tratando de hacer una subconsulta en un left join y me muestra error ( 1248 every derived table must have its own alias), esta es la consulta
SELECT
tprograms.ProgramsID,
tprograms.NroDias,
tprograms.Description,
tprogramdetails.ServiceDate
FROM tprograms Left Join ( SELECT tprogramdetails.ProgramID, datediff(max(tprogramdetails.ServiceDate),min(tpro gramdetails.ServiceDate)) FROM tprogramdetails WHERE tprogramdetails.ProgramID = 'PRO0087' GROUP BY tprogramdetails.ProgramID) ON tprogramdetails.ProgramID = tprograms.ProgramsID
GROUP BY tprograms.ProgramsID, tprograms.NroDias, tprograms.Description, tprogramdetails.ServiceDate
amigos porfa denme una mano