Stuff

UPDATE 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)