[sqlite] Updating the contents of a field in table A with the value of the same field in table B

[audio muze]

> Is it a typo in inner query or you ARE asking for a resource from target?

Apologies all, I'm fast asleep, it should've read:

UPDATE target
  SET resource = (
         SELECT s.resource FROM source s
                 WHERE ( s.ID = ID AND s.resource IS NOT NULL )
);