Actually, you probably would NOT like the results you would get from doing
SELECT FROM FILES
First of all, those probably all need to be LEFT JOINs (after all, not all FILES will have any matches to DELETED, just to take one example).
Secondly, consider what your results would look like.
Let's take a simple case: File 1313 has two matches in DELETE and two matche in SUSPENDED, say.
And let's say you do
You will get *FOUR* records back:
SELECT file.filename, deleted.deleteReason, suspended.suspendReason
LEFT JOIN deleted ON file.fileid = deleted.fileid
LEFT JOIN suspended ON file.fileid = suspended.fileid
And the more matches you have the more records you will get: SQL *must* (by the rules of cartesian joins) give you back *ALL POSSIBLE COMBINATIONS* of matches.
framitz.txt deletedreason1 suspendedreason1
framitz.txt deletedreason1 suspendedreason2
framitz.txt deletedreason2 suspendedreason1
framitz.txt deletedreason2 suspendedreason2
I think, more than likely, you are going to end up deciding on option A.