Select statement problem

Поиск
Список
Период
Сортировка
От Lukasz Brodziak
Тема Select statement problem
Дата
Msg-id AANLkTinVdPQVywTJWOZMPykcoMkhN9QdKTSzCaX5z=mE@mail.gmail.com
обсуждение исходный текст
Ответы Re: Select statement problem
Список pgsql-novice
Hello,

I know the question may appear lame but I have problem with a SELECT
statement for a report. I have two separate statements:
SELECT t1.col1, t1.col2, SUM(t2.end_date::DATE - t2.start_date::DATE)
   from table1 t1, table2 t2, table3 t3 WHERE t1.col3 = t2.col3 and
t3.col4 = t1.col4;

SELECT (Now()::DATE - t2.start_date::DATE) AS days
   from table1 t1, table2 t2, table3 t3 WHERE t1.col3 = t2.col3 and
t3.col4 = t1.col4 and t2.end_date is null;

What I need is to have both statements' results presented in one table
which has 4 columns (t1.col1, t1.col2, "SUM", days). The tables used
are the same in both statements.
--
Łukasz Brodziak
II MU Bioinformatyka

В списке pgsql-novice по дате отправления:

Предыдущее
От: Mladen Gogala
Дата:
Сообщение: Re: Asynchronous I/O in Postgres
Следующее
От: Frank Bax
Дата:
Сообщение: Re: Select statement problem