ALTER TABLE traveltime_submission_timedetails ADD COLUMN paygrade_rate DECIMAL(8,2) after paygrade;

UPDATE 
	traveltime_submission_timedetails td
	JOIN paygrades pg
		ON pg.id = td.paygrade
SET 
	paygrade_rate = pg.rate;