连接表和多个值的SQL查询

So I have three tables that are involved in my problem, 2 regular tables and a join table for a has many and belongs to many relationship. They look like this:So I have three tables that are involved in my