Обсуждение: How to flatten a database table

Поиск
Список
Период
Сортировка

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

Re: How to flatten a database table

От
Thomas Kellerer
Дата:
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?