You can only reference CTEs immediately after they are declared. Once you perform another statement, they're gone.
You'll either have to combine your code, or build your tables first.
Don't forget to mark helpful posts, and answers. It helps others to find relevant posts to the same question.
No comments:
Post a Comment