Anonymous

UPDATE list	SET status = 1		WHERE zip_code IN (SELECT t1.search_zip			FROM data_sept AS t1				LEFT JOIN data_october 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)