how to use a date range in a join

From: chester c young <chestercyoung(at)yahoo(dot)com>
To: sql pgsql <pgsql-sql(at)postgresql(dot)org>
Subject: how to use a date range in a join
Date: 2007-03-12 19:01:45
Message-ID: 208535.83136.qm@web54314.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

trying to do something like

select d.day,
c.name
from [dates between day1 and day2] d
left join c.some_table;

but cannot figure out what to put into the brackets.


____________________________________________________________________________________
Finding fabulous fares is fun.
Let Yahoo! FareChase search your favorite travel sites to find flight and hotel bargains.
http://farechase.yahoo.com/promo-generic-14795097

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas Kretschmer 2007-03-12 19:11:19 Re: how to use a date range in a join
Previous Message Jonah H. Harris 2007-03-11 20:30:49 Re: There is acid without transactions ?