UPDATE SQL mit JOIN
| ID | 269 |
|---|---|
| Link Reference | Not set |
| Link Credits | Not set |
| Link Technical Documentation | Not set |
| PlCodelang | PL/pgSQL |
| PlGroup | Datenbank |
| PlItemTitle | UPDATE SQL mit JOIN |
| Code | UPDATE TableToBeUpdated SET myField1 = 'Update this field' FROM ( SELECT * FROM JoinedTable WHERE cond1 = 1 ) J WHERE J.ID = TableToBeUpdated.ID ; |
| Result Example |