Query leaving out some data

[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!

 

[Jerry Whittle]

In your SQL change the words "INNER JOIN" to "LEFT JOIN".

 

[natira]

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