Try
SELECT * ;
FROM table1 ;
FULL OUTER JOIN table2 ON table1.f1 = table2.f1 ;
LEFT OUTER JOIN table3 ON table2.f2 = table3.f2 ;
WHERE (some condition)
>Using VFP7.
>
>I am trying to perform a 3 table join. Is it possible to do a Full Outer Join and a Left Join in the same select command?
>
>For example:
>
>SELECT * ;
> FROM table1 FULL OUTER JOIN table2 ;
> table2 LEFT OUTER JOIN table3 ;
> ON table1.f1 = table2.f1 ;
> ON table2.f2 = table3.f2 ;
> WHERE (some condition)
>
>Is something like this possible?
>
>Thanks,
>
>Jerryt
--sb--