Hi All,

Attached is the result that I required (the line I highlighted in blue that contains the correct info that I need).

As you can see, I have tons of rows, which includes those infos from the previously deleted files.

I need to know how to exclude those infos from those deleted files from my final output.

Actually I have use the same query for my previous project, and it works just fine. Only this time that it happened this way where the infos from deleted files still appear.

By the way, it's a Windows file.