Display customer data which is not in other table

Expand Post »

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

Similar Threads

Understanding ASP classes in ASP
Display data in drop down in ASP.NET
PHP Dynamic Form HELP! in PHP
Filter JTextField and Display in JTable in Java
Urgently need help in getting Autonumbering ID. Thanks Alot. in Visual Basic 4 / 5 / 6

BillyMako

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

16 posts
since Jan 2008

Permalink

Dec 2nd, 2008

Re: Display customer data which is not in other table

That should be simple :-

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
)

stephen84s

Featured Poster

Reputation Points: 653

Solved Threads: 151

Nearly a Posting Virtuoso

Offline

1,316 posts
since Jul 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MySQL Forum Timeline: a simple application

Next Thread in MySQL Forum Timeline: run the multiple select statement

DaniWeb Message

Cancel Changes

User Name
Password