Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why the results are different?
Message
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01353035
Message ID:
01353077
Views:
13
>You didn't provide enough information about relationship between curLoaded and curImported to answer your question. My guess is that there're multiple records in curLoaded with the same cClient_Account_Number and they match some reoord(s) with the same cClient_Account_Number in curImported. IOW, I suspect that more than one field is involved in relationship between curLoaded and curImported.

There are multiple records with the same cClient_Account_Number in both files, but this field is the best link we can have between these two files.

Is there a way to get all records from curLoaded that were not imported?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform