I have 2 tables, SalesOrderHeader and SalesOrderDetail, connection between them is the SalesOrderID field, as it is presented.
I need to create a query which will show quantity (OrderQty) and sales value (OrderQty * UnitPrice) for every customer (CustomerID) in the month of August, 2012 (OrderDate). Just a heads up, OrderDate is a datetime type of field (example year-month-day 2012-09-18).