Select statement problem
От
Lukasz Brodziak
Тема
Select statement problem
Дата
Msg-id
AANLkTinVdPQVywTJWOZMPykcoMkhN9QdKTSzCaX5z=mE@mail.gmail.com
Список
Дерево обсуждения
Select statement problem Lukasz Brodziak <lukasz.brodziak@gmail.com>
Re: Select statement problem Frank Bax <fbax@sympatico.ca>
Re: Select statement problem Lukasz Brodziak <lukasz.brodziak@gmail.com>
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 по дате отправления