SELECT distinct docs.DocID AS pkid, docs.DocTitle, docs.PublishDate, docs.UnpublishDate, docs.FileSize, docs.FileExt, qryDocFullPathLookup.DocPath, filename FROM tbl_DOC_Documents docs, qryDocFullPathLookup WHERE docs.OwnerID = AND docs.FSL_TableCode = AND unpublishdate <= getdate() AND docs.ContentID = qryDocFullPathLookup.ContentID ORDER BY docs.DocTitle asc