Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Improving sluggish SQL
Message
From
20/12/1999 14:54:16
Ken Wardwell
Fort Wayne, Indiana, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Improving sluggish SQL
Miscellaneous
Thread ID:
00306158
Message ID:
00306363
Views:
25
Maybe this will work better, then maybe it won't

select * , IIF(isNUll(table2.keyfield),"MISSING","FOUND")) as isFound ;
from table1 ;
LEFT JOIN table2 ON table1.keyfield = table2.keyfield ;
HAVING isFound = "MISSING"
Ken Wardwell
Previous
Reply
Map
View

Click here to load this message in the networking platform