>Is this how?
>
>SELECT *;
>FROM mytable ;
>LEFT JOIN yourtable ON mytable.mydata1 = yourtable.yourdata1 ;
>LEFT JOIN yourtable ON mytable.mydata2 = yourtable.yourdata2 ;
>LEFT JOIN yourtable ON mytable.mydata3 = yourtable.yourdata3 ;
>INTO CURSOR rpt
>
>Thanks for the info.
I'd advise against doing this, but going with 2 separate SELECT statements. VFP will only join 2 at a time anyway. At best, you'll get partial optimization.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer