This is what distinguishes a regular CTE from a recursive CTE.
这就是常规 CTE 与 递归 CTE 的区别。
2
Any joins, or even more complex queries, can easily be expressed in the same way by simply pushing the composition of the source for the recursion into a CTE.
任何连接，甚至更复杂的查询，都可以用同样的方法通过将递归源的组成放入一个CTE中来表达。
3
CTE students may go on to university, to training or directly into work.