Join Query problem

[roaml]

Hello,

I need help on a join query. I have a customer table and an Order table (see below).

Customer:
custid (pk)
name
address
city
state

Order:
orderid (pk)
custid (fk)
prodname
qty

I would like to create a report on one customer (custid) and all Orders (orderid) associated with that one customer. How would I join this in a query to get what I need?

 

[scottsanpedro]

You need a normal Inner Join

ie

SELECT Name,prodname,qty
FROM Customer
INNER JOIN Order
ON Customer.Custid = Order.CustId
WHERE (Any criteria you might want) eg Name = "Smith"

Hope that helps

Scott