SELECT     u.UniqueID AS UserID, u.Name AS LastName, u.FirstName, f.Name AS CompanyName, f.Address AS CompanyAddress, f.City AS CompanyCity,
                      s.StateCode AS CompanyState, f.Zip AS CompanyZip, f.Phone AS CompanyPhone, f.Email AS CompanyEmail, p.ProgramName, CONVERT(varchar(10), atp.DateExpire,
                      101) AS DateExpire
FROM         AssignedTrainingPrograms AS atp INNER JOIN
                      Users AS u ON atp.UserID = u.ID INNER JOIN
                      Facilities AS f ON f.ID = u.FacilityID INNER JOIN
                      States AS s ON s.StateID = f.StateID INNER JOIN
                      TrainingPrograms AS p ON p.ProgramID = atp.ProgramID
WHERE     (atp.DateExpire BETWEEN GETDATE() AND DATEADD(dd, 7, GETDATE())) AND (atp.UserID NOT IN
                          (SELECT     UserID
                            FROM          AssignedTrainingPrograms
                            WHERE      (DateAssigned LIKE GETDATE())))
ORDER BY atp.DateExpire