General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only