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.
0