Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL joins
Message
From
08/03/1999 16:18:12
 
 
To
08/03/1999 13:02:41
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00195078
Message ID:
00195337
Views:
19
Thanks Chaim, I'll see if I can find the articles at the FoxPro Advisor site.
One of the queries I have is illustrated by this example:

FROM table_A JOIN table_B ON table_A.x = table_B.x ;
JOIN table_C ON table_A.x = table_C.x ;
Is table_C being joined on table_A or on the result set of the first join?

Also, the above syntax seems to process much faster than the following equivalent which was produced by the Query designer :
FROM table_A JOIN table_B JOIN table_C ;
ON table_A.x = table_B.x ;
ON table_A.x = table_C.x ;

Is there a trap in the first method that I haven't fallen into yet...?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform