Join Query

[hithere]

I have two tables and am trying to connect them with a query.



The first table, Individual Demographics, contains basic information about the person

The second table, Order, info contains order information i.e. date, item, etc. These two tables are joined via the unique individual identifier.

In the query what I would like to do is display only those individuals that have an order and their unique individual identifier. The catch is that I would only like for their name to appear once regardless of how many orders they have. I have tried several different joins and I get back a list of those patients with an order but a name is repeated several times if they have more than one order. Is there any way to get around this?

[orange]

Yes, the answer lies in properly structuring the tables using a process called Normalization. The issue you described is related to the table structures and the duplicate storage of data.

The first few links here can be helpful to you
http://www.rogersaccesslibrary.com/forum/topic238.html

[Newbie11]

I think I already have my tables set up that way. The first table only has demographic information and the second table only has order information. These two tables are linked by only one field, the unique identifier and it's a one to many relationshp. One person can have more than one order.

My problem is coming up with a query that joins the tables listing individuals with an order only once versus multiple times.

[orange]

I think I already have my tables set up that way. The first table only has demographic information and the second table only has order information. These two tables are linked by only one field, the unique identifier and it's a one to many relationshp. One person can have more than one order.

My problem is coming up with a query that joins the tables listing individuals with an order only once versus multiple times.

Please post your tables and relationship structure, and your query sql. and I'm sure someone will offer suggestions/advice/options.

[Aragan]

SELECT DISTINCT Name, Id
FROM [Individual Demographics],Orders
WHERE Id = Orders.IndividualId