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.