Stuff
public text v1 · immutableUPDATE zip_list
SET status = 1
WHERE zip_code ISIN (SELECT t1.search_zip
FROM zip_data_4 AS t1
LEFT JOIN zip_6 AS t2
ON (t1.store_name_1 = t2.store_name_1)
AND (t1.store_name_2 = t2.store_name_2)
AND (t1.address = t2.address)
AND (t1.city_state_zip = t2.city_state_zip)
AND (t1.type = t2.type)
WHERE t2.store_name_1 IS NULL
AND t2.store_name_2 IS NULL
AND t2.address IS NULL
AND t2.city_state_zip IS NULL
AND t2.type IS NULL)