Good morning. I have a query below that requires Total Qty Fulfilled per Item No.

```
select h.cstponbr 'Customer PO No.',
       h.sopnumbe 'Invoice No.', 
       d.itemnmbr 'Item No.',
       d.itemdesc 'Item Description', 
       d.qtyfulfi 'Qty Fulfilled', 
       sum(d.qtyfulfi) 'Total Qty Fulufilled'
from sop10100 h 
inner join sop10200 d on (h.sopnumbe = d.sopnumbe)
where h.cstponbr = @CUSTPONUM
group by d.itemnmbr

```

How will I arrange my query so that I will avoid the error below.

> 
> Column 'sop10100.CSTPONBR' is invalid in the select list because it is
>  not contained in either an aggregate function or the GROUP BY clause.
> 
> 
> 

Thanks in advance.