Thanks Hilmar on UT tip. Slowly slowly I am learning UT tricks. Thanks to you all. :)

No i rarely use full join.
I was trying to mention that the Full join and ON can be used on more than one in the same SQL.


>I am curious - do you use FULL JOIN all the time? I usually use an inner join, and, perhaps in 10-20% of the cases, a LEFT JOIN, but I have never seen the need for a FULL JOIN.
>
>BTW, you can make VFP code more readable, here on the UT, if you use the HTML code PRE, for pre-formatted text. This will preserver spaces. Click on "Reply" to see how I did it.
>
>Regards,
>
>Hilmar.
>
>

>SELECT ;
> FROM ;
>     trial!t1 ;
>    FULL JOIN trial!t2 ;
>   ON  T1.code = T2.t1code ;
>    FULL JOIN trial!t3 ;
>   ON  T2.t1code = T3.t2code ;
>    FULL JOIN trial!t4 ;
>   ON  T3.t2code = T4.t3code
>