SELECT FileInfo.FileId, FileInfo.FileName, FileTypeInfo.FileTypeName, UserInfo.UserName, FileInfo.FilePath, max(OperateLog.OperateTime) FROM FileInfo AS FileInfo INNER JOIN OperateLog AS OperateLog ON FileInfo.FileId = OperateLog.ObjectId INNER JOIN FileTypeInfo AS FileTypeInfo ON FileInfo.FileType = FileTypeInfo.FileTypeId INNER JOIN UserInfo AS UserInfo ON OperateLog.UserId = UserInfo.UserId WHERE (OperateLog.OperateName = '删除') AND (FileInfo.IfDelete = 1) group by FileInfo.FileId, FileInfo.FileName, FileTypeInfo.FileTypeName, UserInfo.UserName, FileInfo.FilePath还是自己想出来的
SELECT FileInfo.FileId, FileInfo.FileName, FileTypeInfo.FileTypeName, UserInfo.UserName, FileInfo.FilePath, max(OperateLog.OperateTime)
FROM FileInfo AS FileInfo INNER JOIN
OperateLog AS OperateLog ON FileInfo.FileId = OperateLog.ObjectId INNER JOIN
FileTypeInfo AS FileTypeInfo ON FileInfo.FileType = FileTypeInfo.FileTypeId INNER JOIN
UserInfo AS UserInfo ON OperateLog.UserId = UserInfo.UserId
WHERE (OperateLog.OperateName = '删除') AND (FileInfo.IfDelete = 1)
group by FileInfo.FileId, FileInfo.FileName, FileTypeInfo.FileTypeName, UserInfo.UserName, FileInfo.FilePath还是自己想出来的