MySQL

RSS

Display customer data which is not in other table

Please support our MySQL advertiser: Programming Forums

•

Posts: 16

Reputation: BillyMako is an unknown quantity at this point

Solved Threads: 0

BillyMako

Offline

Newbie Poster

Display customer data which is not in other table

Dec 2nd, 2008

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

•

Posts: 1,143

Reputation: stephen84s is a glorious beacon of light

Solved Threads: 121

stephen84s stephen84s is offline

Offline

Veteran Poster

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 ?"

Thread Tools Display Modes

Quick Reply to Thread

•

Only community members can participate in forum threads. You must register or log in to contribute.

Similar Threads

Display data in drop down (ASP.NET)
PHP Dynamic Form HELP! (PHP)
Filter JTextField and Display in JTable (Java)
Urgently need help in getting Autonumbering ID. Thanks Alot. (Visual Basic 4 / 5 / 6)
Calendar window is not coming for the Dynamic rows (JavaScript / DHTML / AJAX)
Displaying datagrid on second form (VB.NET)
Problem with Character Arrays (C++)
Understanding ASP classes (ASP Tutorials)
This ought to be simple - extra spaces (PHP)

Other Threads in the MySQL Forum

Previous Thread: a simple application
Next Thread: run the multiple select statement

•

Views: 399 | Replies: 1 | Currently Viewing: 1 (0 members and 1 guests)

•

Thread Tools	Display Modes
Show Printable Version Email this Page	Linear Mode Switch to Hybrid Mode Switch to Threaded Mode