|Subject:||subqueries and group by|
I have a SQL table that contains data accumulated over many months. I need to:
1) extract the rows from with a specified date range
2) consolidate the remaining rows where 2 of the fields both match
3) Sum up the contents of a 3rd field ("Qty") during that consolidation
4) select all fields, both summed and not, of the consolidated rows to import into a 2nd table.