I have the following requirement, if anyone can help me out with the SQL query that would be greatly appreaciate.
I need to get a report from QC/HP ALM for the complete tracebility report from QC (Req->Test -->Exe-->Defects)

I need the following details.

Requirement No/Name Test Set Name Exec Status Defect ID

Req1 Test -1 Pass

Req2 ​ Test -2 Fail 123

Req2 Test-3 Blocked

Thank you for your help