Update MySQL table from another table - SitePoint

I've created a new field in the Jobs table to store the customer ID ... I am now trying to figure out is how best to build the query to populate this ...

www.sitepoint.com