Member Avatar for BillyMako

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

  • 2 Contributors
  • 1 Reply
  • 106 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by stephen84s
Member Avatar for stephen84s

That should be simple :-

SELECT * 
FROM customers
WHERE customers_id NOT IN (
  SELECT customers_id
  FROM orders
)
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.