Solved

Outer Join Showing Too Many Records

Posted on 2006-11-06
3
269 Views
Last Modified: 2012-08-13
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
Comment
Question by:cstraim
3 Comments
 
LVL 15

Expert Comment

by:Simon Ball
ID: 17881667
how many do you get back with an inner join, and how many records are there in table 2?
0
 
LVL 34

Accepted Solution

by:
jefftwilley earned 250 total points
ID: 17881819
you've got 13 duplicate values in the field that you're joining...in table 2
0
 

Author Comment

by:cstraim
ID: 17885053
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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now