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@xxxxxxxxxxxxxxx Please don't top-post. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
