Updating multiple fields with values from another table

Last day we were working with an Application Engine which was relatively simple. It had a single step!

We had to update 3 fields of tableA with values of similar fields from another table, tableB.
Normally we would write an update SQL statement for this, which would have 3 select sub queries and would look something like this.