Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What's the differences between nested and sub join query
Message
From
07/05/2004 10:41:52
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
07/05/2004 08:01:50
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00901574
Message ID:
00901923
Views:
19
>>
>>SELECT *;
>>  FROM a ;
>>    JOIN b ON a.f1 = b.f1 ;
>>    JOIN c ON b.f1 = c.f1
>>
>>
>>Table a is joined with b.
>>Table a is joined with c. Therefore, the part "on b.f1 = c.f1" is not appropriate.
>
>Not so. Table a is joined with b. Then, that result is joined with c, so the condition shown is fine.
>
>Tamar

What you say makes sense; thanks for the clarification.

But then, are the two commands equivalent, or not?
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform