Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FULL JOIN is strange
Message
From
04/10/2003 13:04:14
 
 
To
04/10/2003 11:43:25
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00835102
Message ID:
00835124
Views:
18
Hi Bob,

---
Interesting, but why would you code this? You can get the result you want with:
---

This code is only for explain the bug.

----
SELECT * FROM T2, T1
----

It is not true,
this is not equivalent to
T2 FULL JOIN T1 ON .T.

but is equivalent to (SQL Server CROSS JOIN)
T2 INNER JOIN T1 ON .T.

Moreover, FROM T1,T2,... is the old style SQL joining; on this, FORCE clause is ignored.

Fabio
Previous
Reply
Map
View

Click here to load this message in the networking platform