Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Selecting records from two different tables in one query
Message
De
15/03/2010 12:16:08
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01454516
Message ID:
01454587
Vues:
42
>I'll try later - busy with work right now. I tried on the tables I had in my test database (in SQL Server).

Ok I just tried for you:
                              t6   t5   t4   t3   t2   t1
Client processing time         0    0    0    0    0   16 
Total execution time        2328 2296 3046 2250 2328 5937 
Wait time on server replies 2328 2296 3046 2250 2328 5921 
Two passes. t1,4 (LEFT), t2,5 (NOT IN), t3, 6 (Exists).
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform