Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Custom SQL Returns Only One Record

in BI Publisher Learning Center

I am working on a new report using the below SQL and I am only seeing one Record when running it. I have confirmed that there are many users with no additional assignment details which should cause their records to populate based on the below SQL. I was able to use OTBI to accomplish the ask but would like to know why the custom SQL is not working. Any thoughts are much appreciated!

Custom SQL:

SELECT

pf.person_number

, am.assignment_number

, am.assignment_status_type

FROM
per_assignment_extra_info_m ex
, per_all_assignments_m am
, per_all_people_f pf

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!