Database view to see Approvals

Hello All.

I have created database view to include sc_req_item, sc_request and sysapproval_approver to get a list of pending approvals in a report.

Attached is the image of the tables and the joins. When I "Try It" I get no records.

Please help me find what could be wrong on the join.

Thank you in advance.

-Shree