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
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)