2Build an SQL query for a report

have perhaps 90% of the query completed. I'm having trouble getting the dataset I need. It is a little complex to spell out but simple enough to show. This is the request: --I need all sales orders in house, --I need each sales order to list the configured stain for that order. --I also need the list price for each of those sales order. select top 300 sod.ORDNUM_28 + sod.LINNUM_28 + sod.DELNUM_28 as orderlindel, sod.PRTNUM_28,sum(sod.PRICE_28)--, cs.CFGDES_45 ,[login to view URL](cs.CFGDES_45,sod.PRTNUM_28) from SO_Detail sod left join Configuration_Str cs on sod.ORDNUM_28 + sod.LINNUM_28 + sod.DELNUM_28 = cs.CUORDR_45 where STATUS_28 < '4' group by sod.ORDNUM_28, sod.LINNUM_28, sod.DELNUM_28, sod.PRTNUM_28, cs.cfgdes_45, sod.prtnum_28