- Subject
- Untitled
- Author
- Unnamed
- Description
- No description given
- Posted on
- Mon, 30 Aug 2010 16:56:44 +0200
- Content
-
SELECT Assembly.Quantity * Inventory.SCosts AS MCosts, MCosts + WorkPlan.ProdCosts AS ACosts FROM Parts, Assembly,
Inventory, WorkPlan WHERE Assembly.ChildPartID = 2 AND Assembly.PartID = 1 AND Inventory.PartID =
Assembly.ChildPartID AND Inventory.SuppID = Parts.ShippedBy AND Parts.PartID = Assembly.ChildPartID AND
WorkPlan.PartID = Assembly.ChildPartID