sql - Using UPDATE statement while using multiple WITH

Question

I have a sql statement that returns records that I need and I am using several WITH clauses. I am trying to update one column within the statement.

WITH <name_a> AS (SELECT...),
     <name_b> AS (SELECT...using 'name_a'),
     <name_c> AS (SELECT...using 'name_b')
SELECT * from <name_c>

How would I write the statement if I just want to update a column in the final <name_c> output? Ex.

UPDATE name_c SET fav_color = 'blue' 

for all the records.

I tried just replacing the select with the update statement but I get 'Missing SELECT keyword'.

I found a similar question but it looks like this question focused on updating the value to what was returned from the select statement. Using "WITH" and "UPDATE" statements in the same SQL query

question from:https://stackoverflow.com/questions/65830641/using-update-statement-while-using-multiple-with

Answer 1

Waitting for answers