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:
01353106
Views:
23
>>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?

You have to define what 'not imported' means in terms of tables fields.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform