unknowntpo · September 2, 2022 03:10
diff --git a/add_or_modified.md b/add_or_modified.md
diff --git a/add_or_modified.sql b/add_or_modified.sql
 with add_or_modified as (
 select * from join_table
 where data_id is null
 )
 update temp set username = 'Kevin'
 where id in (select temp_id from add_or_modified);

 select * from temp;
	with add_or_modified as (
	select * from join_table
	where data_id is null
	)
	update temp set username = 'Kevin'
	where id in (select temp_id from add_or_modified);

	select * from temp;