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
3 matches
Mail list logo
