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

Håkan Jacobsson wrote:

  > I don't get it=). How do I input the second daterange in this query?

Through whatever mechanism you are using to issue the query.

 > Also, I have the ID from table1. Its known in the query.

Oops.  I forgot that part in my reply.  So my where clause is
wrong, though easily modified to add "and table1_id = foo".

 > Wouldn't I need to use a UNION for this kind of query?

A union will combine rows (if they're compatible) from two queries,
What you are asking is to assemble columns, which is entirely different.

--
nathan wagner
nw@hydaspes.if.org
Please don't top-post.