query to select all customers who never bought anything?

[ventesites]

hi

 

I am stuck trying to find the right query to select all registered customers who never placed an order...

 

I use this query

 

select c.id_customer, c.firstname, c.lastname, count(o.id_order) as ordercnt
from ps_customer c
left join ps_orders o on c.id_customer = o.id_customer
group by o.id_customer

 

 

but it doesn't return what i want

 

Any help?

 

Thanks

 

Pat

[Logical IT]

Hello,

 

Try this:

 

SELECT  firstname, lastname, email,  date_add, active
FROM   ps_customer
WHERE  NOT EXISTS
  (SELECT ps_orders.id_customer
   FROM   ps_orders
   WHERE  ps_orders.id_customer = ps_customer.id_customer)