Use a subquery:
CFQUERY Name=GetExceptions datasource=#DSN#
SELECT tblEmployees.EmpName, tblEmployees.DeptID
FROM tblEmployees
WHERE tblEmployees.ID NOT IN (
SELECT tblMaster.empid
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.
Basically I
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:
CFQUERY Name=GetExceptions datasource=#DSN#
SELECT tblEmployees.EmpName, tblEmployees.DeptID
FROM tblEmployees
WHERE tblEmployees.ID
3 matches
Mail list logo