Comment by revskill

In the match clause, i don't see the foreign key, how those tables get to know each other to join ?