self-joins and associations