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?