Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Comparing one table to another
Message
 
 
À
26/11/2002 13:09:24
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00727145
Message ID:
00727223
Vues:
16
>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.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform