Re: [GENERAL] Getting the count(*) from two tables and two date ranges in same query

From: Adam Rich <adam.r(at)sbcglobal.net>
Date: Mon Jan 28 2008 - 09:22:24 EST

> Resulting in 4 columns in the ResultSet like:
>
> count(*)_from_table2_between_fromdate1_and_todate1 = X
> count(*)_from_table2_between_fromdate2_and_todate2 = Y
> count(*)_from_table3_between_fromdate1_and_todate1 = Z
> count(*)_from_table3_between_fromdate2_and_todate2 = V
>
> Is this possible?

Select t1.id,
sum(case when t2.date between d1 and d2 then 1 else 0 end) as sum1, sum(case when t3.date between d1 and d2 then 1 else 0 end) as sum2 from t1, t2, t3
where t1.id=t2.id and t2.id = t3.id
group by t1.id

---------------------------(end of broadcast)---------------------------

TIP 4: Have you searched our list archives?

               http://archives.postgresql.org/ Received on Mon Jan 28 09:23:55 2008