UPDATE Cust
SET Cust.[Measure Line] = 'Okay',
Cust.[Measure Header] = 'Okay'
FROM Cust INNER JOIN SHIP_MEANING ON SHIP_MEANING.LOOKUP_CODE = Cust.SHIPPING_METHOD_CODE
WHERE
((Cust.[Measure Line] = 'NotOkay')
AND (Cust.[Unit] IN ('M1','M2','M2'))
AND (Cust.Country='US')
AND (Cust.[AD] IS NOT NULL)
AND (Cust.[AD] > CONVERT(datetime,'24/11/2008',103))
AND (Cust.[AD]-Cust.[SSD]<-7)
AND (Cust.[AD]+Cust.TT-Cust.[RD]>-3)
AND (SHIP_MEANING.[MEANING] not Like '%RDC%'
and SHIP_MEANING.[MEANING] NOT Like '%CALI%' )