DaniWeb IT Discussion Community - View Single Post - Display customer data which is not in other table

Re: Display customer data which is not in other table

Dec 2nd, 2008

That should be simple :-

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
SELECT * 
FROM customers
WHERE customers_id NOT IN (
  SELECT customers_id
  FROM orders
)
SELECT * 
FROM customers
WHERE customers_id NOT IN (
  SELECT customers_id
  FROM orders
)

"Any fool can write code that a computer can understand. Good programmers write code that humans can understand."

"How to ask questions the smart way ?"