Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
For advocates of surrogate foreign keys
Message
 
To
27/11/1998 11:57:23
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00161970
Message ID:
00162008
Views:
31
Jim,

USE Vendor ORDER VendID
USE ApInv ORDER VendKey IN 0
SET RELATION TO VendKey INTO ApInv
SET SKIP TO ApInv

There it is alls et up for you. OR ...

SELECT Vendor.VendID, ApInv.* ;
FROM Vendor OUTER JOIN ApInv ON Vendor.VendKey = ApInv.VendKey ;
ORDER BY 1 ;
INTO CURSOR MYVendInvs
Previous
Reply
Map
View

Click here to load this message in the networking platform