UPDATE primary file with JOIN?

Given two tables...

create table a (fielda char(1), fieldb char(2))
create table b (field1 char(1), field2 char(2))

You can do this.....

update a
set fieldb = (select field2 from b where field1 = fielda)

Notice that it is not a join and you can't do this in V4R2 and prior.

[report a broken link by clicking here]