'Filtering out rows which have condition many to many

probably an easy question, but I struggle on it :

I have tables A, B, and an A-B relation.

How can I get rows from A which doesn't have B matching a condition, like

$query = AQuery->create()
  ->useABQuery()
  ->useBQuery()
  ->filterByName('toto', Criteria::NOT_EQUAL)
  ->endUse()
  ->endUse()

This kind of query will match A which have B 'toto' and 'titi', where I would like to filter out A completely if B exists.

Thank you



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source