| Description |
We need a SQL view that will take all posted Blending transactions together with their details (raw materials consumed). Listed below are the columns needed in this view.
* Blending Transaction Id
* Blend Date
* Primary Product Id (Item Id)
* Primary Product (string)
* Primary Product Qty (gallons)
* Blending Agent Product Id (Item Id)
* Blending Agent Product (string)
* Blending Agend Qty (gallons)
* Finished Good Product Id (Item Id)
* Finished Good Product (string)
* Finished Product Qty (gallons)
|