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
>