There are two tables ps_customer and ps_address.
ps_customer contains: id_customer and customer.email ps_address contains: id_customer and few other fields.
I want to select customers who's data is not present in ps_address table. I'm using Sql Query:
SELECT id_customer, customer.email FROM ps_customer WHERE id_customer NOT IN SELECT id_customer FROM ps_address;
But it throws the error that there is something wrong with query
SELECT id_customer FROM ps_address