Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Compare Tables
Message
 
 
To
05/02/2008 12:17:57
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01289634
Message ID:
01289813
Views:
12
>Anything simple to compare tables and show the differences? Even it was SQL that created a cursor of the records that do not match would be fine.

if you wantto track different records between 2 table
SELECT table1.pk as pk1, table2.pk as pk2 FROM ;
                 table1;
FULL OUTER JOIN  table2 ON table1.pk=table2.pk;
WHERE ISNULL(table1.pk) OR ISNULL(table2.pk)
Previous
Reply
Map
View

Click here to load this message in the networking platform