Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Selecting records from two different tables in one query
Message
From
05/07/2010 11:37:56
Naomi Nosonovsky
Wisconsin, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Selecting records from two different tables in one query
Miscellaneous
Thread ID:
01454516
Message ID:
01471412
Views:
43
>Just want to share this link http://sqlinthewild.co.za/index.php/2010/04/27/in-exists-and-join-a-roundup/ that contains performance results for
>IN/EXISTS/INNER JOIN and NOT IN/NOT EXISTS/LEFT JOIN by Gail Shaw.

More interesting articles on this same topic

http://weblogs.sqlteam.com/peterl/archive/2007/09/20/Finding-records-in-one-table-not-present-in-another-table.aspx
and (with timings) http://weblogs.sqlteam.com/peterl/archive/2009/06/12/Timings-of-different-techniques-for-finding-missing-records.aspx
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform