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 08:01:50
 
 
To
06/05/2004 21:22:04
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00901574
Message ID:
00901883
Views:
18
>
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform