How to flatten a database table

[mai fawzy <maifawzy.emaifaw@xxxxxxxxx>]

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