OraFAQ Forum: SQL & PL/SQL » how to have multiple lines with 2 colums

Home » SQL & PL/SQL » SQL & PL/SQL » how to have multiple lines with 2 colums

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to have multiple lines with 2 colums [message #20469]

Mon, 27 May 2002 11:44

Philippe
Messages: 7
Registered: May 2002

Junior Member

Hi all,
I have a table T with 4 columns
Col1, Col2, Value1, Value2
C1, , 1,
C1, C3, 1, 1
C2, C1, 3, 2
.....
I want a result like
C1, 4
C2, 3
C3, 1
I've tried
select C1, sum(value1) from T group by C1
UNION [[ALL]]
select C2, sum(value2) from T group by C2
but i got something like
C1, 2
C2, 3
C1, 2
C3, 1
can somebody help me?

Report message to a moderator