Inserting into table using multiple common table expressions CTE

Database

Inserting into table using multiple common table expressions CTE

Hi,

I'm wondering if someone has a workaround for performing an insert from a select statement inside of a CTE.  My CTE has multiple 'with' statements and from what I've been seeing, Teradata only supports an insert/select in a CTE with one 'with' statement.

Thanks

1 REPLY
Teradata Employee

Re: Inserting into table using multiple common table expressions CTE

Teradata only supports one WITH. But within the one WITH it is possible to specify as many CTEs as desired.