Incorrect code:
WITH source1 as (
SELECT blah FROM blah
),
source2 as (
SELECT moreblah FROM source1
)
INSERT INTO newtable FROM source2;Correct solution:
INSERT INTO newtable
WITH source1 as (
SELECT blah FROM blah
),
source2 as (
SELECT moreblah FROM source1
)
SELECT * FROM source2;