>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