hi i keep my purchase and issue in my transaction table with type 0 and 1. now i want to retrieve sum of purchase and issue in single row with two column. my query is.........
select (case when TransType = 0 then SUM(Amount) end) PurchaseAmt, (case when TransType = 1 then SUM(Amount) end) IssueAmt from TransMaster where TransType in (0,1) group by TransType
abov query return following thow row. [PurchaseAmt IssueAmt
13600123.00 NULL
NULL 12952262.00][1]
but my expectation is single row as following. PurchaseAmt IssueAmt
13600123.00 12952262.00
is it possible ? thanks to all.