Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only