tags:

views:

2

answers:

0
Q: 

JPQL query for ManyToMany relationship?

Hi all,

I have two entities: Student and Course with manytomany relationship. I wanna give a student a list of the courses he did not choose yet. For example, If we have 6 courses, and stduent A has selected course 1 , 3, 5, we should list course 2,4 in the available courses list for him. What's the right JPQL for that? Thanks.

related questions

Saving object with ManyToMany relation
Query examples in a many-to-many relationship
hibernate criteria - querying tables in n:m relationship
Using the entity framework to add existing entities to a collection on a newly created entity.
Is it possible to add many-to-many relationship without initialize collection in NHibernate?
Code review for many-to-many relationship UI implementation in CoreData
How do I implement a many-to-many association from an entity to itself in Entity Framework?
How do you do many to many table outer joins?
Linq2Sql Many:Many question, How would you do this?
Help with many-to-many relation
Twitter-like "follow user" and "watch this" problem
SQL how to search a many to many relationship
Dynamic Data Filter on many-to-many relationship, how?
MySQL strict select of rows involving many to many tables
How to deal with a Many-To-Many Relation in my API
Querying ManyToMany relationship with Hibernate Criteria
Most succinct LINQ To SQL for taking COUNT(*) of either side of many-to-many?
Many-to-many relationships in ASP.NET Dynamic Data
Interesting Many-many sql join.
Many to Many delete cascade in NHibernate
How to write a SQL statement which gets results via a relationship table? (many to many)
JPA - many to many relationship of a table with a compound-key with itself
LINQ to entities - Building where clauses to test collections within a many to many relationship.
Many to Many Relationship in MS Dynamics CRM 4.0 - How to?
SQL many-to-many matching