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

Поиск

Список

Период

Сортировка

How to flatten a database table

От

mai fawzy

Дата:

22 июня 2010 г., 05:38:14

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

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

Дата:

22 июня 2010 г., 05:45:37

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?

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

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

How to flatten a database table

Re: How to flatten a database table