Query leaving out some data


N

natira

Access 2003
I think this must be a pretty easy question, but unfortunately I'm unable to
identify the solution . . .

SIMPLIFIED SUMMARY
Customer Table
CustomerID Company Name
3301 ABC Industries
3302 My Store, Inc.
3304 A1 Company
3305 Mom & Pop's Shop

Delivery Table
CustomerID OrderID
3301 988374
3302 788362
3303 700287
3304 679028

Query should pull CustomerIDs for all Orders and list the CustomerID,
OrderID and Company Name. (SQL = SELECT Deliveries.CustomerID,
Customers.CompanyName, Deliveries.OrderID
FROM Customers INNER JOIN Deliveries ON Customers.CustomerID =
Deliveries.CustomerID;)

Query Datasheet shows only:
CustomerID Company Name OrderID
3301 ABC Industries 988374
3302 My Store, Inc. 788362
3304 A1 Company 679028


I would like the OrderID for CustomerID #3303 to show up even though there
is no cooresponding Customer ID in the Customer Table:

CustomerID Company Name OrderID
3301 ABC Industries 988374
3302 My Store, Inc. 788362
3303 700287
3304 A1 Company 679028

Can anyone tell me how I can make this work? Thanks!
 
Ad

Advertisements

Ad

Advertisements

N

natira

See, I knew it should be easy to solve. Thanks, Jerry, and have a very HAPPY
NEW YEAR!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top