I must be doing something wrong.....
SELECT DISTINCT dbo.Absences.HID AS "HID", dbo.RequestTasks.Created AS "Created", dbo.Absences.ProjectNumber AS "ProjectNumber", dbo.Absences.syscreated AS "syscreated", dbo.cicmpy.cmp_wwn AS "cmp_wwn" FROM ((dbo.Absences LEFT OUTER JOIN dbo.cicmpy ON dbo.Absences.CustomerID = dbo.cicmpy.cmp_wwn) LEFT OUTER JOIN dbo.RequestTasks ON dbo.Absences.ID = dbo.RequestTasks.RequestID) WHERE dbo.Absences.Type = 88 AND select * from absences where syscreated <= (getdate()-90)
I get an invalid syntax near select