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

SQL Query for Employee Goals Report

in Performance Management

Summary:

I’m trying to build an Oracle SQL query to generate a report on Employee Goals Details, but I’m having trouble getting the Department and Division columns to appear correctly.


Content (please ensure you mask any confidential information):

I’ve managed to join the goals tables and retrieve most of the information, but Department and Division are not populating correctly in my current query.

Has anyone written a similar query or can guide me on the correct joins to pull Department, Division, Section, and Unit accurately?
Any help or sample SQL would be greatly appreciated. 🙏

Thanks in advance,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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