Learning JPA and JPQL. I have 3 database tables (as example): TVShow and Genre, and a Join table show_genre (having only show_id and genre_id) for the many-to-many relationship between tvShow and genre.
I have 2 annotated Java entities :
private Set<TVShow> tvShows;
private Set<Genre> genres;
Is there a JPA or JPQL way to find a specific row in this Many to Many, like given a genre id, and a tvShow id, can I find the specific genre object for the given tvShow id?