Solved

SQL Select Statement

Posted on 2002-04-26
1
161 Views
Last Modified: 2013-12-28
I'm fairly new to SQL, but need to know how to do the following.

I have 2 tables (table A and Table B) both have employees. I want to know the total number of employees in table A that do not exist in table B). The comlexity is that some of the emplyees in table A are repeated therefore they may exist more than once in table A but will only have one record if they exist in table B.

Many thanks !!

Pardeep

0
Comment
Question by:pardeep_nagra
1 Comment
 
LVL 6

Accepted Solution

by:
xSinbad earned 50 total points
ID: 6976127
What are the field names in these tables? Something like this should do the job.


SELECT DISTINCT tblA.*
FROM tblA LEFT JOIN tblB
ON tblA.EmployeeName = tblB.EmployeeName
WHERE tblA.EmployeeName is null

Cheers
Marcus
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Lot of troubles with windows 10 7 59
sleep laptop 20 70
Problem to App source 6 70
is a 3rd party application able to write events to the security log? 4 32
In this article, I will show you HOW TO: Install VMware Tools for Windows on a VMware Windows virtual machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, using the VMware Host Client. The virtual machine has Windows Server 2016 instal…
How to record audio from input sources to your PC – connected devices, connected preamp to record vinyl discs, streaming media, that play through your audio card: Vista, Windows 7, Windows 8, Windows 8.1 and Windows 10 – both 32 bit & 64.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…

809 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