Hello,

Sorry for my english, I'm french. I want to know the best way to do the following request.

The database contains the following table :

Table Level (ID, LABEL) ; ex : [{1, 'beginner'}, {2, 'pro'}]
Table Categorie (ID, LABEL, ID_LEVEL) ; ex : [{1, 'Science', 1}, {2, 'Business', 1}, {3, 'Economy', 2}]
Table Lessons (ID, LABEL, ID_CATEGORIE) ; ex : [{1, 'Mathematics', 1},{2, 'Biology', 1}]

I want to get the following results :

Each Categorie and the Lessons associated for the level 1 (beginner).

-- {1, 'Science', 1}
----- {1, 'Mathematics', 1}
----- {2, 'Biology', 1}
-- {2, 'Business', 1}

Can you please help me to do the minimum of request as possible ?

Those tables are only examples.

Thanks in advance,

Sincerely,