Select *
from customer.c1
where c1.customer_id = 4
and exists (Select 'x'
from customer.c2
where c1.customer_id = c2.customer_id
and = ccustomer = 'y')

Seems to me that this would do the same thing:
select *
from customer
where customer_id = 4
and ccustomer = 'y'