>>>You are using an INNER JOIN so if a store doesn't post anything, it won't
>>>show up in the result set and you won't know they didn't post. Try:

>>>SELECT ulog.storeno, ulog.postno, ulog.upldate, ;
>>>cnt(ulog.uplproc) as posted , store.phone ;
>>>  FROM storelst Store LEFTF OUTER JOIN ulogserv ulog   ;
>>>    ON ulog.storeno = store.store ;
>>> WHERE upldate between lddate1 and lddate2 ;
><b>   or isnull(lddate1) ;</b>
>>> group by 1,2,3

>>
>>Nope. that still misses the no transaction groups?
>>
>>__Stephen
>
>The WHERE clause is throwing it off because the LEFT OUTER JOIN will produce a
>null value in the field. I think the bold statement will take care of
>it.

Or you can use the NVL() function in the field list:

SELECT store.storeNo, NVL(ulog.postNo, 0), NVL(ulog.uplDate, {}), ;
etc.