Relationships in mutating joins

Many-to-one: primary key is in y.

Example with left join or inner join: