ALTER TABLE rental
ADD COLUMN payment_id INT;
UPDATE rental
SET payment_id=payment.payment_id
FROM payment
WHERE (payment.rental_id=rental.rental_id)