need clean way to copy col vals from one rec to another

create table foo (name text, company text, job text);
insert into foo (name,company,job) values ('joe','ge','engineer');
insert into foo (name) values ('sue');

What I want to do is map joe's company and job over to the sue record, ending up with....
'sue' 'ge' 'engineer'

Is there a quick/clever.efficient way to do this?

Thanks in Advance