Here's what I'm trying to do.
query A select * employees who have signed in today.
query B selects all employees who should sign in by job code
and active status.
these both give correct results when run independently.
Now I'm trying to compare the two tables to see who hasn't
signed in today by querying the queries. I can easily get everyone
who has signed in but I have tried every way I can find to get who
hasn't signed in. I keep coming back to this which doesn't work:
<cfquery name="remaining" dbtype="query">
Select queryB.LastName, QueryBFirstName,
queryB.employeeID,QueryA.EmpID
FROM QueryA,QueryB
WHERE queryA.employeeID <> QueryB.empid
</cfquery>
Will someone please give me some help on this? I've tried so
many ways my brain is in a never ending loop 🙂
Thanks!