SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

query problem(solved)

617179Feb 19 2008 — edited Apr 10 2008

hi frs,

i want to display work_location and office_location in a report.which is in table
HR_LOCATIONS_ALL
Which has two location_id

work location : location_id from per_all_assignments_f &
office location: location_id from hr_all_organization_units

how to get both i a have attached the query what i have created but not getting correct values

Thanks
Rajesh

Message was edited by:
Rajesh.mani

Message was edited by:
Rajesh.mani

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 18 2008

Added on Feb 19 2008

4 comments

636 views