I've 2 tables with many-to-many relationship => users, roles.
I need to find all users THAT AREN'T IN ANY ROLE.
In SQL it can be done:
WHERE `id` NOT
is the joining table of many to many relationship from
How can obtain the same result with
table is an automated mapping from doctrine, if i try to use it, I get "entity not found"
How can I do the same result with
I can't be able to using the user_role table in my entity, because it's autogenerated with many-to-many relathionship annotation (or can I use it?).