Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FULL JOIN is strange
Message
From
06/10/2003 06:57:42
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
04/10/2003 18:18:57
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00835102
Message ID:
00835294
Views:
19
>Hi Hilmar,
>
>The thing is becoming boring.
>
>When I find one what that it does not work, many answer to me that not servants to nothing.
>But then, why the members of the VFPT have lost time to implement it?
>
>Fabio

In this case, not exactly: You gave an example for a full join without a join condition. I would expect this to give a Cartesian product, and I have used this myself (but with another syntax).

What I am wondering about is, what use is a full join with a join condition? Note that this is not the example you gave.
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