One to many relationship

A

adsl

Dirk Goldgar said:
Note: since this is plainly a question about a query, you should have
posted it to the .queries newsgroup alone. Certainly the .formscoding
and .modulescoding have no conceivable relevance.

To answer your question, you need a LEFT JOIN instead of an INNER JOIN:

SELECT tblCustomer.*, tblOrders.*
FROM tblCustomer LEFT JOIN tblOrders
ON tblCustomer.ID = tblOrders.CustomerID;

That will include all records from tblCustomer, and only the matching
records from tblOrders.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
 
A

adsl

Shadow said:
Any kind of advice is much appreciated to help me overcome this problem.

I have a Customer and Orders table In an access application with a one to
many relationship.
I have also created a query by the following rst:
--------------------------------------------------------------
SELECT tblCustomer.*, tblOrders.* FROM tblCustomer INNER JOIN tblOrders ON
tblCustomer.ID = tblOrders.CustomerID;
--------------------------------------------------------------
Running this query, shows only those Customers who have some records in
Orders table. Is there any way to make this query to show all Customers
even if they haven't any records in Orders table?


many thanks for any kind of advice.
Access 2003
 

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