simple sub- query

SELECT

sakila_payment_0.payment_id AS sakila_payment_0_payment_id,

sakila_payment_0.customer_id AS sakila_payment_0_customer_id,

sakila_payment_0.staff_id AS sakila_payment_0_staff_id,

sakila_payment_0.rental_id AS sakila_payment_0_rental_id,

sakila_payment_0.amount AS sakila_payment_0_amount,

sakila_payment_0.payment_date AS sakila_payment_0_payment_date,

sakila_payment_0.last_update AS sakila_payment_0_last_update

FROM

sakila.payment sakila_payment_0

WHERE

sakila_payment_0.customer_id IN(

SELECT

sakila_customer_0.customer_id

FROM

sakila.customer sakila_customer_0

WHERE

sakila_customer_0.customer_id = '1');