using leftouterjoin from single table insqlserver.

See more:

SQL-Server

SQL-Server-2008

HI all i had a requirement where i need to get a values from single table , the table has 3 colms id,name,value for id=1 i have 4 names (a,b,c,d) and has values for it like for a there are 10 values for b 10 values same for c and d, and for id=2 i have only 3 names (a,b,c) with 10 values for each , now my requirement here is to get the result in this way

name  id       values(sum(values))        id          values<br />
<br />
a       1             15                   2            187<br />
b       1              20                  2            168<br />
c       1             18                   2            132<br />
d       1             31                   Null         Null

i tried left outer join and inline query but i failed ,are they failing beacuse of same table values and group by i am not sure about it is there any way i can achieve it please guide me thanks