sub consulta en Left Join

[alfil123]

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

[alfil123]

hola queridos amigos llegue hasta aca
SELECT
tprograms.ProgramsID,
tprograms.NroDias,
tprograms.Description,
t1.nrodias
FROM tprograms Left Join ( SELECT tprogramdetails.ProgramID, datediff(max(tprogramdetails.ServiceDate),min(tpro gramdetails.ServiceDate)) as nrodias
FROM tprogramdetails WHERE tprogramdetails.ProgramID = tprograms.ProgramsID GROUP BY tprogramdetails.ProgramID) t1 ON t1.ProgramID = tprograms.ProgramsID
GROUP BY tprograms.ProgramsID
pero el esta en tprograms.ProgramsID de la sub consulta, no reconose la tabla tprograms, nose si alguien puede ayudarme porfa como se puede salvar esto

[alfil123]

ok chicos asuto resuelto
gracias

[alfil123]

SELECT
tprograms.ProgramsID,
tprograms.NroDias,
tprograms.Description,
t1.nrodias,
minima
FROM tprograms Left Join ( SELECT tprogramdetails.ProgramID, min(tprogramdetails.ServiceDate) minima, datediff(max(tprogramdetails.ServiceDate),min(tpro gramdetails.ServiceDate))+1 as nrodias
FROM tprogramdetails, tprograms WHERE tprogramdetails.ProgramID = tprograms.ProgramsID GROUP BY tprogramdetails.ProgramID) t1 ON t1.ProgramID = tprograms.ProgramsID
GROUP BY tprograms.ProgramsID



esta es la que trabaja