Nesting MJoin to represent two chained one-to-many relationships.
Nesting MJoin to represent two chained one-to-many relationships.

Is it possible to nest MJoin? If yes how. Thank you.
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
No sorry. MJoin doesn't actually even support a left join at the moment (although that's something we plan to add). For the moment if you need multiple levels of Mjoin nesting you'd need to take an approach like this.
Allan