UPDATE FX_UPS_TNT
SET DAS = 'D'
WHERE EXISTS
(SELECT DAS.UPS_D
FROM DAS
WHERE DAS.UPS_D = FX_UPS_TNT.ZipCode)
Basically I have 2 tables here.
Table: FX_UPS_TNT
Columns: ZipCode, UPS_TNT, FX_TNT, Winner, DAS, DAS_E
Rows: 41,333
Table: DAS
Columns: UPS_D, UPS_D_E
Rows: 12,259
Needless to say...