Torna al Thread
SELECT TOP 5 Documents.Title, Documents.AutoDate, Projects.Name AS Project, Documents.ID
FROM [Documents],[Projects]
WHERE (Documents.Groups in (SELECT CStr(IDProject) FROM [Members] WHERE (IDuser = " + userID + ")
AND (IDProject in (SELECT ID
FROM [Projects]
WHERE (typ<>4 AND typ<>1) ))
) AND Documents.Groups = CStr(Projects.ID) AND Documents.Status < 3
AND (DateDiff('m', (Documents.Autodate), (now)) <= 6 )) ORDER BY Documents.AutoDate DESC