C
Clayman
I am now ready to start validating the data in my database. It's extracted
from several Excel Tables. One problem I'm encountering is that I need a
One-to-Many relationship between "EmpData" (One) and "CurrentData" (Many).
But I've got more records in "EmpData" than in "CurrentData" There needs to
be at least one record in "CurrentData" (715) for every record in "EmpData"
(734).
I've already run
SELECT COUNT (*) FROM eachtable
and
SELECT COUNT (DISTINCT *) FROM eachtable
to verify that there are no duplicates.
I'd like to build a query (preferably with SQL 'cuz I'm an old command-line
programmer who hates GUIs) that will find the records in "EmpData" without a
corresponding record in "CurrentData".
The PriKey in "EmpData" is FileNum. It is the relationship field (ForKey) in
"CurrentData".
Thanks for all your help!
from several Excel Tables. One problem I'm encountering is that I need a
One-to-Many relationship between "EmpData" (One) and "CurrentData" (Many).
But I've got more records in "EmpData" than in "CurrentData" There needs to
be at least one record in "CurrentData" (715) for every record in "EmpData"
(734).
I've already run
SELECT COUNT (*) FROM eachtable
and
SELECT COUNT (DISTINCT *) FROM eachtable
to verify that there are no duplicates.
I'd like to build a query (preferably with SQL 'cuz I'm an old command-line
programmer who hates GUIs) that will find the records in "EmpData" without a
corresponding record in "CurrentData".
The PriKey in "EmpData" is FileNum. It is the relationship field (ForKey) in
"CurrentData".
Thanks for all your help!