Something like
INSERT * INTO Calls_center FROM Emp_calls WHERE NOT EXISTS (SELECT * FROM Calls_center WHERE Calls_center.FirstName = Emp_calls.FirstName AND ...
Thanks. Will play with this ...
>
>I have two tables that I would like to compare. I am uploading text delimited data to table 1 (Emp_calls.dbf). I would like to take that database and compare it against the holding table (Calls_center.dbf) If a record is in the Emp_calls database and NOT in the Calls_center database, then I want to insert it into the call_center database.
>
>Here is the field structure to both tables. They are both structured the same.
>
>First name
>Last name
>proc_date
>proc_time
>contact_lname
>contact_fname
>
>I basically want to cmpare all fields to determine which one makes the record a unique record that needs to be added to the call_center database
Thanks in Advance.
J. Turner