Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 279
  • Last Modified:

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
0
cstraim
Asked:
cstraim
1 Solution
 
Simon BallCommented:
how many do you get back with an inner join, and how many records are there in table 2?
0
 
jefftwilleyCommented:
you've got 13 duplicate values in the field that you're joining...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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now