SELECT SubFolderInternalPath FROM tbl_FSC_SubFolders WHERE SubFolderCode = 'DOC' SELECT MainFolder, SubFolder, FileName, PswrdProtect, DocPassword FROM tbl_DOC_Documents a, tbl_FSC_Content b WHERE a.DocID = #url.id# AND a.ContentID = b.ContentID