Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Selecting records from two different tables in one query
Message
De
05/07/2010 11:37:56
Naomi Nosonovsky
Wisconsin, États-Unis
 
 
À
29/06/2010 19:21:16
Naomi Nosonovsky
Wisconsin, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Re: Selecting records from two different tables in one query
Divers
Thread ID:
01454516
Message ID:
01471412
Vues:
44
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform