Outer Join Showing Too Many Records

I am working with a query that joins two tables with an outer join

Table 1 has 9174 records.  When I join Table 1 to Table 2 with an outer join (inlude ALL records from table 1 and only those records from table 2 where the joined fields are equal)

For some reason when I run the query i get 9187 records back. (I should only be getting 9174 records back based on how I setup the query)


Any thoughts?

Thanks

Cory
cstraimAsked:
Who is Participating?
 
jefftwilleyConnect With a Mentor Commented:
you've got 13 duplicate values in the field that you're joining...in table 2
0
 
Simon BallCommented:
how many do you get back with an inner join, and how many records are there in table 2?
0
 
cstraimAuthor Commented:
Thank you ..i did a comparison and saw that there were duplicates I was unaware of.  Thanks for your help.  I should have comared the tables to begin with!!

Cory
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.