cstraim
asked on
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
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
how many do you get back with an inner join, and how many records are there in table 2?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
Cory