select c.company,q.createtime, Q.emp_FIRST_NAME, q.emp_lastname, q.client_id, c.client_id as contact_client_id from wce_contact c inner join wce_qualifications q on c.uniqueid = q.entityid where not c.client_id = q.client_id

Update q
Set    q.client_id = c.client_id
From   wce_contact c 
       inner join wce_qualifications q 
         on c.uniqueid = q.entityid 
where  not c.client_id = q.client_id