> Alan McDonald wrote:
>
> > you said above that store_no is a PK - how can you deliver DISTINCT pk
> > values unless it is just select pkfield from table?
>
> No, he said that (SKU, STORE_NO) constitutes a PK. The GROUP BY 1 is
> obviously a typo, probably because he was experimenting with variations
> of the query to see what the results would be. He meant GROUP BY STORE_NO.

so you're allowed to assume and conclude but I'm not allowed to ask
questions because I just misread his "obvious" typos?
Huh?