select y.* from y join x on y.x = x.id where x.name = 'your desired name'.