Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help with Select statement
Message
From
06/06/2001 08:41:28
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
 
To
06/06/2001 08:07:19
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00515639
Message ID:
00515661
Views:
14
>Table1 is related to Table2.
>
>I want to run a SELECT on Table1 and only obtain records that DO NOT have a related record in Table2.

Kevin,

I've been trying to do this in a Select statement, but I get everything except what you're looking for. Can you use "Copy To Table3 For EOF('Table2')" while the relationship is active to get the subset in a table, arrary or cursor? I'll keep plugging away to see what I come up with if the above doesn't handle it...

Regards, Renoir
Previous
Reply
Map
View

Click here to load this message in the networking platform