Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Capturing new records
Message
De
10/12/2019 18:10:11
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01672220
Message ID:
01672222
Vues:
73
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform