UPDATE
	dtb_customer as b
SET
	pref = (
		SELECT 
			(
				SELECT 
					(SELECT id FROM mtb_pref WHERE  mtb_zip.state = name)
				FROM 
					mtb_zip 
				WHERE 
					dtb_customer.zip01 || dtb_customer.zip02 = zipcode
			) as a
		FROM
			dtb_customer 
		WHERE
			customer_id = b.customer_id
		)
WHERE
	pref IS NULL