Added IN tests with a join in the parent