Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Strange SQL behavior
I've noticed some strange sql behavior that maybe someone knows a fix for. I was getting net sales information by state and the sql was something like:
select state, sum(sale) from sales group by state
note: there were a few records where the state was blank and set exact was on
The result of each state pulled in the sales from the blank state also. The each state was overstated by the sum of the blank state. This didn't always happen. It happened when I ran the query 2 or 3 times. If I exited foxpro and then come back in and reran the query it would work properly. Any idea of how to fix this problem
Thanks
Suivant
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