Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Comparing one table to another
Message
De
26/11/2002 14:24:44
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00727145
Message ID:
00727226
Vues:
20
>>Hi All,
>>I have two tables that I need to compare. I was thinking of scaning through one, and comparing the data row-by-row to the other. Has anyone ever done this kind of theing before?
>>TIA,
>
>select * from FirstTable ;
>union ;
>select * from SecondTable ;
>into cursor curFirstSec
>
>This cursor will have all records from the first table + only records, which are different from the second table.

Good idea Nadya, thanks!
Winn Pauley
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform