Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement