Re: connecting multiple INSERT CTEs to same record?

h the data select * from new_data_with_ids ; === Thank you! Regards, - Assaf Gordon

connecting multiple INSERT CTEs to same record?

contrived example, in my use-case I need to update several tables. Of course it can be done on the application-level, one-by-one inserting new 'student' then inserting its 'classes' - but I prefer to avoid that. Sadly, I can't assume the student name is unique, so I can't "join" on it. Thanks! - Assaf Gordon