Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
FULL JOIN is strange
Message
De
04/10/2003 13:04:14
 
 
À
04/10/2003 11:43:25
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00835102
Message ID:
00835124
Vues:
19
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform