Nested Query for newbie?

From: PM (anonymous_at_discussions.microsoft.com)
Date: 05/14/04 

Date: Fri, 14 May 2004 08:58:59 -0700

Hi
thanks for reading
I have 2 tables. The first has employee information and
the second has
payroll information. I need to find out people who are not
in the
payroll but in the employee table.
Since the payroll has multiple instances i have to filter
it and find
out for each payroll.
I don't think i have explained it very well so here is the
data set.
hope someone can help me with this.
Thanks in advance
prit

Tbl Employee
PlanID SSN
1001 111111111
1001 222222222
1001 333333333

TblPayrolldetail
IDNum PlanID SSN
1 1001 111111111
1 1001 222222222
2 1001 222222222
2 1001 333333333

Required RESULT required(Missing employees for each pay
period)
IDNum SSN
1 333333333
2 111111111

Relevant Pages

  • RE: Batch Payroll
    ... > 2 - set up multiple records for each employee, with one record for each type ... > employee's name etc, with the detail section allowing date, hours, pay rate & ... I use this method for looking up payroll data by employee... ...
    (microsoft.public.access.forms)
  • Re: Principle of Orthogonal Design
    ... EMPLOYEE relation with two keys, Badge# and SSN. ... Note that in the PAYROLL relation, there is a tuple for each ... for each workday even if there isn't one in the CLOCK relation. ...
    (comp.databases.theory)
  • Re: Productivity
    ... I agree that payroll is a very good example of a process that is handled ... well by batch processing, but I also don't think it HAS to be. ... These procedures could be triggered against each employee ... account on a staggered schedule (say, one every minute, or whatever, ...
    (comp.lang.cobol)
  • Re: Principle of Orthogonal Design
    ... EMPLOYEE relation with two keys, Badge# and SSN. ... Note that in the PAYROLL relation, there is a tuple for each ... for each workday even if there isn't one in the CLOCK relation. ...
    (comp.databases.theory)
  • Re: Table design
    ... to pay ahead for 'Vacation' pay. ... Then it is a matter of programmatically looping through all the timesheet ... > I have an employee table and a payroll table. ...
    (microsoft.public.access.tablesdbdesign)