Sum one field in different fields based on conditions on another field with group by

[vijay6]

Hey mehdi483, try this code...

SELECT DName, PName, SUM(a), SUM(b) FROM (SELECT DName, PName,
SUM(CASE WHEN Type='01' THEN Quantity ELSE 0 END) AS a,
SUM(CASE WHEN Type='02' THEN Quantity ELSE 0 END) AS b
FROM Table_1
GROUP BY PName, DName, Type) AS c GROUP BY PName, DName

Note: For my convinence i changed column names and table name,

VchID -> ID
VchType -> Type
VchQty -> Quantity
PartName -> PName
DlName -> DName
VoucherTable -> Table_1

[mehdi483]

Thanks dear vijay6! that was exactly what I wanted. I'm really grateful