We don't really know what you are trying to accomplish, so maybe an example will help. Here is a Database View showing one Case with one attachment, and one Case that has 3 attachments. The first 3 columns are from the Case table, the last 3 columns are from the Attachment table.
Instead of a report or list that displays like this, showing one row for each attachment record, what is it that you want to see? Do you need to see attachment data other than the File name? Does the File name / attachment appearance need to be a link which downloads the file?
The closest to that I can come up with using a simple list view or report is a pivot table on the database view, which would look something like this
or this with more data displayed - you can choose the row and column fields:
On each you can drill-down / click-through to see the underlying records in a list view.
