| TABLE 1 Valid and Invalid Set Operations in a Recursive CTE | |
| Set Operations | Valid? |
| AM UA RM UA AM | Yes |
| RM UA AM UA AM | Yes |
| AM U AM UA RM | Yes |
| AM UA RM UA RM | Yes |
| AM U RM | No |
| AM UA RM U AM | No |
| RM UA AM U AM | No |
| AM: Anchor MemberU: UNION | |
| RM: Recursive MemberUA: UNION ALL | |