Update statement with a inner join

[LKBrwn_DBA]

Try this:

update carrier b
set (company_key
    ,carrier_name
    ,carrier
    ,carrier_code
    ,delivery_days
    ,ship_method ) = 
    (select company_key
          , carrier_name
          , carrier
          , carrier_code
          , delivery_days
          , ship_method
       from preload_carrier a
      where a.carrier_key = b.carrier_key)
where exists (
    (select 1
       from preload_carrier a
      where a.carrier_key = b.carrier_key)
;