Re: How to flatten a database table

mai fawzy, 22.06.2010 10:38:
> 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
>
> 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.

Based on which condition?