Entity joins generally always require that you specify an ON clause. If you want to join everything, that’s called a cross join, so you’d use select c from Person c cross join House s where c.id = '123123', but seriously, why would anyone want to do that?