Display customer data which is not in other table
 

What i want to do is display all the customers data which is in the 'customers' table where their 'customers_id' is NOT IN the 'customers_id' field in the 'orders' table.

I hope i made sense!

Thanks,
Billy

Re: Display customer data which is not in other table
 

That should be simple :-

SELECT * 

FROM customers

WHERE customers_id NOT IN (

  SELECT customers_id

  FROM orders

)