Query pulling in record more than one time

C

cmk

I have 3 simple tables. The first table has one unique field tied to the
second table. The Second table has three fields tied to the third table. The
tables are joined by left outer joins. When I run the query, a couple of the
records show up more than one time - b/c the field in the first table sees
that it is in the second table two times, thus I get four records. Instead
of two. Any ideas on what I need to do
 
D

Duane Hookom

Your query should expect unique values joining on one side of each join. The
first table apparently has a unique field that joins to many in the second
table. The three fields in the second table should be unique if joined to
more than one record in the third table.
 
Top