update c

set c.nif = (needs reference or is ambiguous).nif

from contribuintes c

join...etc...

Either the above with reference, or just take out the c and preface with full name. Sorry for little detail, just getting up and running this morning.