Aggregate a table, with 3 Keys and 5 Values

[#1]

I have ha table which looks like this one:

Date is 2010-01-01

Key1 is DBIIA

Key2 is CSSK58BC

and I have different Values in 5 columns.

How can I aggregate this table so I have just one row with all values in the same row. I shoud be possible to aggregate the keys, they are the same.

thank you in advanced.

Thomas

[#2]

up

[Anonymous]

Hi

Put all the EXPression in a single Exp seperated by OR

It wil work fine

DO let me knw wether it worked

Thnxs

Sachin Sahu