Re: Getting the count(*) from two tables and two date ranges in same query - Mailing list pgsql-general

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