Query Help please

Steel Contributor

I am still quite a beginner at this SQL querying, so I appreciate any help on this. I have pulled the data I need using the below query. Now I need to group the data by cmp_name and sum the ivh_totalcharge for each cmp_name. Also, need to make sure I pull distinct records from the field ord_hdrnumber from the invoiceheader table. Thank you for any help, I appreciate it.

1 Reply

@Tim Hunter write ivh_totalcharge  with SUM(ivh_totalcharge ) after WHERE clause, write GROUP BY for other columns