Queries for Quality Issue related relationships and workflow approvers

Summary:

I am trying to build queries to get all the relationships and workflow approvers related to quality issues but i am getting only one of the multiple rows available.

Please help

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

SELECT DISTINCT

  eiv.name       "IssueName",

  eiv.issue_number   "IssueNumber",

  eab.issue_number   "ItemName",

  ear.src_obj_type   "DestObjType",

  ear.src_obj_id    "DestObjId",

  ear.dest_obj_type   "SrcObjType",

  ear.dest_obj_id    "SrcObjId"

FROM

  enq_issue_relationship_v    ear,

  enq_issues_vl         eiv,

  enq_issues_vl         eab,