Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Confused on a ! in issue
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Confused on a ! in issue
Miscellaneous
Thread ID:
00402304
Message ID:
00402304
Views:
32
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?
Next
Reply
Map
View

Click here to load this message in the networking platform