Select Group by issue

[inarobis]

Hello

I have this data and I would like to group them

Have these record

Date ID A B
12.07.2005 1 450
12.07.2005 1 124
12.07.2005 2 340
12.07.2005 2 145

How I can Have this

Date ID A B
12.07.2005 1 450 124
12.07.2005 2 340 145


the table is ROOM

Can Someone help that issue?

Inarobis

 

[cLFlaVA]

looks like maybe you want...

  select Date, ID, sum(isnull(A,0)) A, sum( isnull(B,0)) B
    from ROOM
group by Date, ID

*cLFlaVA
----------------------------
[tt]( <P> <B>)¹³ * (<P> <.</B>)[/tt]

[URL unfurl="true"]http://www.coryarthus.com/[/url]

 

[dpgirl]

How about this?

select tmp1.DateField, tmp1.RecordID, tmp2.A, tmp3.B
from 
  (select DateField, RecordID
  from [i]tablename[/i]
  group by DateField, RecordID) tmp1
join 
  (select DateField, RecordID, A
  from [i]tablename[/i]
  where A is not null) tmp2
on tmp1.DateField=tmp2.DateField 
and tmp1.RecordID=tmp2.RecordID
join 
  (select DateField, RecordID, B
  from [i]tablename[/i]
  where B is not null) tmp3
on tmp1.DateField=tmp3.DateField 
and tmp1.RecordID=tmp3.RecordID

 

[inarobis]

thank you for your answers



Ina