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	)