Question d’entretien chez AppTcom

How we get this result between those tables from the database? (pseudo code question)