Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP6 vx VFP8 SQL
Message
From
14/05/2004 07:39:25
 
 
To
13/05/2004 14:37:17
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00903642
Message ID:
00904004
Views:
20
>I first changed the ! EXIST portion to a.FR # k.FR on a LEFT JOIN between the tables and it worked just fine.

Better would probably be a NOT IN subquery, which wouldn't need to be correlated, though actually, I think the VFP engine figures out how to optimize that one.

Tamar
Previous
Reply
Map
View

Click here to load this message in the networking platform