PrepZone Logo
PrepZone
Back to Database

Database · Medium

Update employee salaries from a staging table using a join.

DatabaseSQL QueriesSeniorDML

Answer preview

PostgreSQL joins in an UPDATE through the FROM clause: name the target once after UPDATE, the source tables in FROM, and the join predicate in WHERE.…