Pull from Two Tables 1

rbyrne1 · Jun 20, 2008

I have two tables as follows:

CUSTOMERS
customernum
customername

ORDERS
ordernum
customernum
partnum

"SELECT customers.customernum, customername, ordernum FROM customers, orders WHERE partnum=123 and customers.customernum=orders.customernum"

I'm trying to pull a recordset of all customers that ordered part #123. The problem is that if a customer ordered three parts, one of which was #123, it's going to pull three records (one record for each . All I want is the single order number for the order that contains this part number.

I would think this would be an easy thing to do, but I'm all out of ideas.

TNGPicard · Jul 8, 2008

Use the keyword distinct to get rid of duplicates in your output.

Code:

SELECT DISTINCT customers.customernum, customername, ordernum FROM customers, orders WHERE partnum=123 and customers.customernum=orders.customernum

rbyrne1 · Jul 8, 2008

DISTINCT!!! That's it! Thank you.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Pull from Two Tables 1

rbyrne1

MIS

TNGPicard

Technical User

rbyrne1

MIS

Similar threads

Part and Inventory Search

Sponsor