Database View - Viewing Related Lists under a Change Request

[Patrick Rodrigu]

Hello, 

I'm trying to create a database view to show related items under a change request (for reporting purposes) 

Below is what I've created so far: 

What am I missing?

Thank you for any help/guidance!

[Jaspal Singh]

What is the actual expectation?

[Patrick Rodrigu]

A user needed to create a report on the above highlighted fields but was unable to since the information came from multiple tables. I'm creating a database view so that all the fields in the related list can be pulled on the same report.