How to flatten a database table

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