Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Tuesday, November 14, 2017

Query to give sum of items with condition from multiple tables

SQLServerCentral » Latest topics
Query to give sum of items with condition from multiple tables
I have these tables: LineItemSubParts, CostCodeSubCategories, CostCodes and LineItems
In the LineItemSubParts table there are fields named Quantity, MQuantity and Cost
In the CostCodes table there are field named CostCodeID and CostCode

No comments: