I've included a simplified diagram of my database and my query so far which doesn't work

Code: Select all
SELECT house.id, house.propertyname
FROM
residences AS house,
residents_to_residences AS r2r,
residents AS person
WHERE residence_id != house.id
GROUP BY house.id
ORDER BY house.propertyname