On Tuesday, August 13, 2019, Alban Hertroys <haramrae(at)gmail(dot)com> wrote:
>
> > On 13 Aug 2019, at 13:10, stan <stanb(at)panix(dot)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.