[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Getting the count(*) from two tables and two date ranges in same query
From:       Sam Mason <sam () samason ! me ! uk>
Date:       2008-01-31 12:08:30
Message-ID: 20080131120830.GA1887 () frubble ! xen ! chris-lamb ! co ! uk
[Download RAW message or body]

On Wed, Jan 30, 2008 at 09:52:17AM +0100, H??kan Jacobsson wrote:
> I just realised that issuing the SQL on one table produces the correct count.
> 
> SELECT sum(case when table2.date between '2007-07-13' and '2007-07-13' then 1 else 0
> end) as sumx FROM table2 WHERE id = n;
> 
> This is working alright.
> So the problem should lie in the last part:
> 
> from table2, table3
> where table2.id = table3.id
> and table2.id = n;
> 
> I think I need the UNION statement instead?

Did you try something similar to the code I posted?


  Sam

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org/
[prev in list] [next in list] [prev in thread] [next in thread]