-340 THE COMMON TABLE EXPRESSION `name` HAS THE SAME IDENTIFIER AS ANOTHER OCCURRENCE OF A COMMON TABLE EXPRESSION DEFINITION WITHIN THE SAME STATEMENT

Explanation
 The common table expression name name is
used in the definition of more than one common table expressions in
the statement. The name used to describe a common table expression
must be unique within the same statement.

System action
 The statement cannot be processed.

Programmer response
 Correct the error by changing the name
of one of the common table expressions.

SQLSTATE
 42726

-340 THE COMMON TABLE EXPRESSION name HAS THE SAME IDENTIFIER AS ANOTHER OCCURRENCE OF A COMMON TABLE EXPRESSION DEFINITION WITHIN THE SAME STATEMENT

Explanation

System action

Programmer response

SQLSTATE

-340 THE COMMON TABLE EXPRESSION `name` HAS THE SAME IDENTIFIER AS ANOTHER OCCURRENCE OF A COMMON TABLE EXPRESSION DEFINITION WITHIN THE SAME STATEMENT