sub consulta en Left Join

[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