Solved

Query table and only return results NOT in another table in ACCESS

Posted on 2014-11-25
2
159 Views
Last Modified: 2014-11-25
I have 2 tables Humres with a field em_id and another table (dbo_emptrain) that has a field empID.  The Humres table has ALL employees listed in it, the emptrain table has only employees that we have assigned something in this database.  I want to run a query that shows me only employees that haven't been assigned to the emptrain table.
0
Comment
Question by:sharris_glascol
2 Comments
 
LVL 34

Accepted Solution

by:
PatHartman earned 500 total points
ID: 40464495
If you don't know how to create a left join, then use the "unmatched" wizard to create the query for you.

Select ...
From tblA Left Join tblB On tblA.em_id = tblB.empID
Where tblB.empID Is Null;
0
 

Author Closing Comment

by:sharris_glascol
ID: 40464511
Thanks I have done numerous queries and feel dumb this was so simple.
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

746 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

10 Experts available now in Live!

Get 1:1 Help Now