> On 13 Aug 2019, at 13:10, stan <stanb@xxxxxxxxx> 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.
