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