Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SELECT WHERE field IN (SELECT field FROM Table)
Message
From
29/03/2001 07:47:36
Kevin Lawrence
Cornwall Council
United Kingdom
 
 
To
29/03/2001 06:27:07
Nicholas Mason
London, United Kingdom
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: SELECT WHERE field IN (SELECT field FROM Table)
Miscellaneous
Thread ID:
00489440
Message ID:
00489785
Views:
9
>The second query wouldn't optimise the referral table because you are selecting all the records from the referral table where they match records records in sclient tab so all referral records have to be checked

Nick

Thanks, that's all I needed to know.

Kev
Previous
Reply
Map
View

Click here to load this message in the networking platform