simonthompson99/update_table_from_lookup.sql

Last active January 13, 2021 12:35

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/simonthompson99/663170b607a418498ebc83a4b6dfdd0c.js"></script>
Save simonthompson99/663170b607a418498ebc83a4b6dfdd0c to your computer and use it in GitHub Desktop.

Download ZIP

Revisions

simonthompson99 revised this gist Jan 13, 2021. No changes.

simonthompson99 created this gist Jul 24, 2020.

update_table_from_lookup.sql

-Original file line number
+Diff line change
@@ -0,0 +1,12 @@
+    update schema.table t
+    set cola = u.cola
+    from
+    (
+        select * from (values
+          (1, 'fdjkl'),
+          (2, 'reiuuio'),
+          (3, 'adfgd')
+        ) as t (id, cola)
+    ) u
+    where t.id = u.id
+    ;