Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Selecting records from two different tables in one query
Message
From
15/03/2010 12:16:08
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01454516
Message ID:
01454587
Views:
41
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform