alter table rfqs add job_description varchar(2000) not null default '' after job_id;

update rfqs r
join jobs j on r.job_id = j.id
set r.job_description = j.description;