General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Hi,
>
>On VFP this is not true:
>Example 1 ( test symmetric )
>SELECT * FROM T1 FULL JOIN T2 ON .T.
>SELECT * FROM T2 FULL JOIN T1 ON .T.
Interesting, but why would you code this? You can get the result you want with:
SELECT * FROM T2, T1
Also, if you add a real join expression you do get expected results:
SELECT * FROM T1 FULL JOIN T2 ON T1.F1 = T2.F2
Even the below example give the results you are expecting if you just use
SELECT * FROM T2, T1
I guess my question would be, what is the use of a join if you don't specify the join expression.
BOb
Previous
Next
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