Forum Stats

  • 3,836,833 Users
  • 2,262,197 Discussions
  • 7,900,124 Comments

Discussions

Multiple Join On Single Table

871355
871355 Member Posts: 48
edited May 7, 2015 5:49AM in Discoverer

I have two folders defined under business area from database tables called EMP and PROJECTS

EMP table has the following columns

emp_number

emp_name

projects table has the following columns

proj_id

proj_initiated_by

proj_started_by

proj_closed_by

Joins are generated as

emp.emp_number -> projects.proj_initiated_by (one_to_many)

emp.emp_number -> projects.proj_started_by (one_to_many)

emp.emp_number -> projects.proj_closed_by (one_to_many)

In Discoverer Desktop, when I'm trying to create a report, I'm able to see

employee name of person who initiated (initiated_by)

However for started_by and closed_by, I am not sure how to display employee name of person who started and closed project.

employee name of person who started (started_by)

employee name of person who started (closed_by)

Appreciate any help on this

Tagged:
This discussion has been closed.