sqlite3 - Nested Update Query in SQLite -

i'm trying update range of records based on join on same table in sqlite3 using application sqliteman, can't seem right syntax , have tried number of methods. latest iteration of update query below

update  workcodes wc2 set  wc2.subcodeof = wc1.id  workcodes wc1  inner join  workcodes wc2 on  wc1.jemenawc=wc2.workcode 

i think want try sub-select:

update     workcodes wc2 set     wc2.subcodeof = (          select wc1.id          workcodes wc1          wc1.jemenawc = wc2.workcode )