select w.Name,E.EquipClass,(L.StorageCount*E.PlannedPrice) as 庫存價格
from warehouse W
left outer join Location L on W.ID=L.ID
left outer join Equip E on L.EquipID=E.ID
left outer join EquipStructure EC on EC.ID=E.ID
group by w.Name,EC.EquipClass
from warehouse W
left outer join Location L on W.ID=L.ID
left outer join Equip E on L.EquipID=E.ID
left outer join EquipStructure EC on EC.ID=E.ID
group by w.Name,EC.EquipClass
select a.name,d.equipclass,(b.storagecount*c.plannedprice) as 庫存金額 from warehouse a
left join location b on a.id=b.warehouseid left join equip c on b.equipid=c.id left join
EquipStructure d on c.id=d.id
group by a.name,d.equipclass,b.storagecount,c.plannedprice
select a.name,d.equipclass,(b.storagecount*c.plannedprice) as 庫存金額 from warehouse a
left join location b on a.id=b.warehouseid left join equip c on b.equipid=c.id left join
EquipStructure d on c.id=d.id
select a.name,d.equipclass,(convert(int,b.storagecount)*convert(int,c.plannedprice)) as 庫存金額 from warehouse a
left join location b on a.id=b.warehouseid left join equip c on b.warehouseid=c.id left join
EquipStructure d on c.id=d.id
from a,Location b,Equip c, EquipClass d
where a.id=b.warehouseID and b.EquipID=c.id and EquipStructureID=d.id
group by a.name,EquipClass
select w.Name,E.EquipClass,sum(L.StorageCount*E.PlannedPrice) as 庫存價格
from warehouse W
left outer join Location L on W.ID=L.ID
left outer join Equip E on L.EquipID=E.ID
left outer join EquipStructure EC on EC.ID=E.ID
group by w.Name,EC.EquipClass