How to achieve this type of join in prisma? Where the join is conditional? Only execute the join depends on the parent type... So there's no useless join lookup because you know no value will ever be there because of table type