[GENERAL] How to flatten a database table

[mai fawzy]

Hi All,

I have a table that has the following fields:

   ID    Money      Date           State
   1       20         2010-01-01   done
   2       10         2010-01-02    done
   3
   .
   .
   .
   .
   n


I need to select the values from this table to join them 2 another select
statement but the problem that I need to flatten this table first.
 I need the returned values to be as one row. how can this be implemented??


Thanks a lot,
Mai