Hi Fabio

Thanks for the code. Unfortunately, it does not return the correct data. Not sure why. I had similar problems which is why I was built the two view sample I posted. The view you posted returns the same value for all prices and a zero rate which I found somewhat baffling so I tried removing the SUMming and discovered that It was returning the same record a number of times but this still didn't explain why all the prices were the same. I will look at it further and see what I can come up with.

I had discovered some documentation on subqueries and thought I would give it a go but have discovered that apparently this will not work until VFP9. It was this feature that I was trying to get going rather than trying to condense the view by summing/grouping. If you know of any way I subquery a view I would very much appreciate anything you can tell me.

I will have a play with the view again and see if I can work something along the lines you have done.

Thanks once again
Geoff


In-fact your grouping into a two LEFT JOIN is strange for me. Check the primary keys.

With two steps views, you use the UNION and VFP implement a UNION DISTINCT.