General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
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