Absence category and absence types under this category query. — Cloud Customer Connect
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

Absence category and absence types under this category query.

I need a SQL query that returns information about the absence category and the absence types connected to this category. I would be grateful for the query you can share as an example.

I can find these two information from ANC_ABSENCE_TYPES_F_TL , ANC_ABSENCE_CATEGORIES_F_TL tables, but I could not join them correctly.

Thank you.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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