Hmmm, does the title of this post make sense? Probably not but it’s not an easy concept to squeeze into a few words.
Here’s the scenario, I have two tables A and B in Doctrine ORM with a many-to-many relationship defined in table AB.
Now, I want to find all objects in A that do not have a relationship with an object in B via AB.
Here’s what I have:
->from( 'A a' )
->leftJoin( 'A.AB ab' )
->where( 'ab.id IS NULL' )
This works but is it the best way?