Paula,
 
This should get you by the syntax error, but doesn't explain the no rows exist.
 
UPDATE fecuploadtemp SET frcode = biofile.frcode FROM fecuploadtemp, biofile WHERE biofile.idno = fecuploadtemp.idno
 
Is idno an integer or text?
 
Dawn

Reply via email to