UPDATE SQL mit JOIN
ID | 300 |
---|---|
Link Reference | Not set |
Link Credits | Yannik :-) |
Link Technical Documentation | Not set |
PlCodelang | BigQuery |
PlGroup | Datenbank |
PlItemTitle | UPDATE SQL mit JOIN |
Code | UPDATE `project.dataset.table1` t1 SET t1.target_column = t2.source_column FROM `project.dataset.table2` t2 WHERE t1.join_key = t2.join_key; |
Result Example |