[Solved] Relation to many and get without this
In SQL, this type of query needs what is known as an EXCEPTION JOIN. Some RDBMSs actually implement this as a separate type (such as DB2), while others need to use a workaround. In your case, it amounts to (in SQL): SELECT User.* FROM User LEFT JOIN UserHouse ON UserHouse.id_user = User.id WHERE UserHouse.id_user IS … Read more