Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Confused on a ! in issue
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Confused on a ! in issue
Divers
Thread ID:
00402304
Message ID:
00402304
Vues:
33
I am counting transactions posted from outer locations to the main office.

Each store is suposed to pass in 6 files. I need to find the stores that sent NONE or any # less than 6

This code does fine:
SELECT ulog.storeno, ulog.postno, ulog.upldate, ;
cnt(ulog.uplproc) as posted , store.phone ;
FROM ulogserv ulog JOIN storelst Store ;
ON ulog.storeno = store.store ;
WHERE upldate between lddate1 and lddate2 ;
group by 1,2,3

I thought that "having posted <>6 " would do fine but it does not?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform