>Thanks. But I need to combine records of the same table. Thanks anyway.

The following code assumes that field 'keyfield' uniquely identifies the recors in the table.

SELECT t1.* ;
  FROM table_a t1, table_a t2 ;
  WHERE t1.keyfield <> t2.keyfield ;
  INTO CURSOR CombinedValues