G
Guest
I have two data tables from separate data dumps.
eBizHoursFrom9-19Dump (9,548 records)
eBizHoursRecorded (9,493 records)
I am trying to use an unmatched query to find the records from 9-19 that are
missing in the other data table. I thought I was following instructions
properly but my query results include ALL 9.548 records instead of just the
missing ones. I included both tables in the query, linked each field to its
counterpart, set the join for all records from 9-19 and only matching for
HoursRecorded. Added criteria for "is null" for the Employee field in the
Hours recorded.
Can anyone tell me what I have done wrong in this query? Here is my SQL.
Thanks very much for your help.
*******
SELECT [eBizHoursFrom9-19Dump].Employee, [eBizHoursFrom9-19Dump].HourType,
[eBizHoursFrom9-19Dump].Revision, [eBizHoursFrom9-19Dump].EmpNum,
[eBizHoursFrom9-19Dump].PPEdate, [eBizHoursFrom9-19Dump].AcctTemplate,
[eBizHoursFrom9-19Dump].Project, [eBizHoursFrom9-19Dump].Vendor,
[eBizHoursFrom9-19Dump].Function, [eBizHoursFrom9-19Dump].Task,
[eBizHoursFrom9-19Dump].NightHours, [eBizHoursFrom9-19Dump].TotalHours,
[eBizHoursFrom9-19Dump].OrgCode
FROM [eBizHoursFrom9-19Dump] LEFT JOIN eBizHoursRecorded ON
([eBizHoursFrom9-19Dump].OrgCode = eBizHoursRecorded.OrgCode) AND
([eBizHoursFrom9-19Dump].TotalHours = eBizHoursRecorded.TotalHours) AND
([eBizHoursFrom9-19Dump].NightHours = eBizHoursRecorded.NightHours) AND
([eBizHoursFrom9-19Dump].Task = eBizHoursRecorded.Task) AND
([eBizHoursFrom9-19Dump].Function = eBizHoursRecorded.Function) AND
([eBizHoursFrom9-19Dump].Vendor = eBizHoursRecorded.Vendor) AND
([eBizHoursFrom9-19Dump].Project = eBizHoursRecorded.Project) AND
([eBizHoursFrom9-19Dump].AcctTemplate = eBizHoursRecorded.AcctTemplate) AND
([eBizHoursFrom9-19Dump].PPEdate = eBizHoursRecorded.PPEdate) AND
([eBizHoursFrom9-19Dump].EmpNum = eBizHoursRecorded.EmpNum) AND
([eBizHoursFrom9-19Dump].Revision = eBizHoursRecorded.Revision) AND
([eBizHoursFrom9-19Dump].HourType = eBizHoursRecorded.HourType) AND
([eBizHoursFrom9-19Dump].Employee = eBizHoursRecorded.Employee)
WHERE (((eBizHoursRecorded.Employee) Is Null));
*******
Ann Scharpf
eBizHoursFrom9-19Dump (9,548 records)
eBizHoursRecorded (9,493 records)
I am trying to use an unmatched query to find the records from 9-19 that are
missing in the other data table. I thought I was following instructions
properly but my query results include ALL 9.548 records instead of just the
missing ones. I included both tables in the query, linked each field to its
counterpart, set the join for all records from 9-19 and only matching for
HoursRecorded. Added criteria for "is null" for the Employee field in the
Hours recorded.
Can anyone tell me what I have done wrong in this query? Here is my SQL.
Thanks very much for your help.
*******
SELECT [eBizHoursFrom9-19Dump].Employee, [eBizHoursFrom9-19Dump].HourType,
[eBizHoursFrom9-19Dump].Revision, [eBizHoursFrom9-19Dump].EmpNum,
[eBizHoursFrom9-19Dump].PPEdate, [eBizHoursFrom9-19Dump].AcctTemplate,
[eBizHoursFrom9-19Dump].Project, [eBizHoursFrom9-19Dump].Vendor,
[eBizHoursFrom9-19Dump].Function, [eBizHoursFrom9-19Dump].Task,
[eBizHoursFrom9-19Dump].NightHours, [eBizHoursFrom9-19Dump].TotalHours,
[eBizHoursFrom9-19Dump].OrgCode
FROM [eBizHoursFrom9-19Dump] LEFT JOIN eBizHoursRecorded ON
([eBizHoursFrom9-19Dump].OrgCode = eBizHoursRecorded.OrgCode) AND
([eBizHoursFrom9-19Dump].TotalHours = eBizHoursRecorded.TotalHours) AND
([eBizHoursFrom9-19Dump].NightHours = eBizHoursRecorded.NightHours) AND
([eBizHoursFrom9-19Dump].Task = eBizHoursRecorded.Task) AND
([eBizHoursFrom9-19Dump].Function = eBizHoursRecorded.Function) AND
([eBizHoursFrom9-19Dump].Vendor = eBizHoursRecorded.Vendor) AND
([eBizHoursFrom9-19Dump].Project = eBizHoursRecorded.Project) AND
([eBizHoursFrom9-19Dump].AcctTemplate = eBizHoursRecorded.AcctTemplate) AND
([eBizHoursFrom9-19Dump].PPEdate = eBizHoursRecorded.PPEdate) AND
([eBizHoursFrom9-19Dump].EmpNum = eBizHoursRecorded.EmpNum) AND
([eBizHoursFrom9-19Dump].Revision = eBizHoursRecorded.Revision) AND
([eBizHoursFrom9-19Dump].HourType = eBizHoursRecorded.HourType) AND
([eBizHoursFrom9-19Dump].Employee = eBizHoursRecorded.Employee)
WHERE (((eBizHoursRecorded.Employee) Is Null));
*******
Ann Scharpf