Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Performance
Message
From
26/01/2000 12:43:57
Walter Meester
HoogkarspelNetherlands
 
 
To
26/01/2000 09:47:32
Michael Dougherty
Progressive Business Publications
Malvern, Pennsylvania, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00322775
Message ID:
00322961
Views:
18
Michael,

>Select < clause A >;
>Union Select < clause B > Where NOT Exists Select < clause A >

AFAIK, VFP executes three queries to accomplish this task. IMO there is a better way to accomplish the same goal. You can leave the last query out because the union combines those two and filters out the duplicates. In that case the query would be something like:

Select < clause A > Union Select < clause B >

HTH

Walter,
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform