All Forums Database
bmsouthern 1 post Joined 05/16
27 Aug 2016
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

ToddAWalter 316 posts Joined 10/11
28 Aug 2016

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

You must sign in to leave a comment.