On Tuesday, August 13, 2019, Alban Hertroys <
haramrae@gmail.com> wrote:
> On 13 Aug 2019, at 13:10, stan <stanb@panix.com> wrote:
>
> select
> project.proj_no ,
Removed columns that get in the way of your desired result. You can’t have both details and the sum over them in a meaningful way.
Sure you can, at least generally, with Window Functions/Expressions (i.e., OVER)
David J.