QC check between two tables

I have two tables and would like to have a query that looks at the Name field in both tables to see if they match or dont and display the findings.

Primary table is table one
CMILLERAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PortletPaulfreelancerCommented:
how to the 2 tables join (what fields)?

e.g.
select t1.name, t2.name
from (table1 t1
inner join table2 t2 ON t1.id = t2.id)
0
CMILLERAuthor Commented:
Example:

In table one, I have a specific name showing up. In table two they dont. I need a query that looks at both tables and displays the names that dont show up in table two.
0
PortletPaulfreelancerCommented:
:) yes
but how to the 2 tables relate to each other?
(what are the fields involved in the join?)

Perhaps you could list the fields and we can take an educated guess.

and suggestion:  
use the actual table names and field names, it will be easier for you in the long run as the code we suggest can be tried without "translation"
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

CMILLERAuthor Commented:
I dont have them joined yet. We could use SSAN.

Table one is "Mandoc" table two is "MDCPDS"
0
PortletPaulfreelancerCommented:
My Access skills are super rusty but I think this will work
select Mandoc.name, MDCPDS.name
from (Mandoc
inner join MDCPDS ON Mandoc.SSAN= MDCPDS.SSAN)
where Mandoc.name <> MDCPDS.name

Open in new window

by the way, if "<>" doesn't work try "!="

{+ edit, got SSAN wrong, fixed}
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
CMILLERAuthor Commented:
it found some names but the issue is that the person that I know doesnt exist in Table 2 - MDCPDS is not showing up in the query.

there is no record for the person in table 2, he only has a record in table one.
0
PortletPaulfreelancerCommented:
a note on the join used above (inner join)

that join will ONLY locate SSAN values that are matched in BOTH tables
If there is a possibility that records exist in one table but not the other, then we need an "outer" join. If you use the query design view and drag SSAN's to form a join (defualts to an inner join), you can then alter the nature of the join to outer along these lines:

In the Diagram pane of the Query Designer, drag the name of the join column in the first table or query and drop it onto the matching column in the second table or query.
In the Diagram pane, right-click the join line, and then click Properties.
On the Join Line tab, under Include rows, do one of the following:
   To create a left outer join, select the first check box — for example, All rows from Mandoc.
   To create a right outer join, select the second check box — for example, All rows from MDCPDS.
   To create a full outer join, select both check boxes — for example, All rows from Mandoc and All rows from MDCPDS.
( quote is derivation from office.microsoft.com )
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.