EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 11:04 AM
To: CF-Talk
Subject: RE: CFQUERY: All employees who haven't entered data...
Use a subquery:
SELECT tblEmployees.EmpName, tblEmployees.DeptID
FROM tblEmployees
WHERE tblEmployees
use subquery.
either NOT IN or WHERE NOT EXISTS
On Mon, 30 Sep 2002, Angel Stewart wrote:
> Hey all,
>
> Is there a simple SQL statement that would allow me to select all the
> employees...or all the EmpIds that are NOT in the Master table..
>
> So I have tblEmployees and tblMaster.
>
> Basicall
Use a subquery:
SELECT tblEmployees.EmpName, tblEmployees.DeptID
FROM tblEmployees
WHERE tblEmployees.ID NOT IN (
SELECT tblMaster.empid
FROM tblMaster
Hey all,
Is there a simple SQL statement that would allow me to select all the
employees...or all the EmpIds that are NOT in the Master table..
So I have tblEmployees and tblMaster.
Basically I want to display all the bad bad people that did not enter
their time for a specific period...an exce
4 matches
Mail list logo
