Hey, yag,

Thanks for responding.

In your example...

SELECT T1.f1, (SELECT f2 FROM foo2 T2 WHERE T2.f1=T1.f1) AS foo2 ;
FROM foo1 T1

If I can do a SUM() on t2.F2 and group by T1.F1, then that would be the ticket! I have about a dozen instances of multiple one-to-many relationships where I had to do multiple queries or use a UDF. It's always been a pain, especially in the command window during testing.

After VFP8 came out, I had tried many of the Joe Celko techniques that I'd come to use in SQL Server, only to find that some didn't work in VFP.

In fairness, I don't believe MS SQL is fully SQL-92 compliant, but if the gap is narrowed in VFP9, I'll be thrilled.

Thanks,
Kevin