SQL: cross-table updates
Because I always forget how to do it, and always have to look up the syntax... Here's how to update table A with values from table B.
UPDATE A
SET name = B.name
FROM B
WHERE A.id = B.id;
SET name = B.name
FROM B
WHERE A.id = B.id;
