Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 35DF09FB6A8 for ; Mon, 12 Mar 2007 16:01:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 75085-08-2 for ; Mon, 12 Mar 2007 16:01:46 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web54314.mail.yahoo.com (web54314.mail.yahoo.com [206.190.49.124]) by postgresql.org (Postfix) with SMTP id 4703B9FB639 for ; Mon, 12 Mar 2007 16:01:46 -0300 (ADT) Received: (qmail 88595 invoked by uid 60001); 12 Mar 2007 19:01:45 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=ob4eOWNVbCulGK0i0KbNnwO/F5Zfg98JQjqaWDzQlp+kg8wN3+UugHwXYV7Uxv5JY1dtT4+sW+eB60G/42bUAIHrfNfPJTFhJn9nw3WDKR49SUPFKlifr10d9lPtMM/YVpLpTY2RBTBHSd7W486ClAka9UkdFjtXFRHikYkKXeM=; X-YMail-OSG: aF1onPcVM1la6TU4gc_F11k_2wbI5w.4QSXX5rgKEQLqvHtqFjl7XB8EEikygZqM6fwKEW.GgzOGWcmSISY3uw9siUZgVpQD_tM6ZJYx6LRtnKAHf_duEMf6ZzOBmBdHUpuJ7FfhIpKHwq3D60S324E- Received: from [24.10.123.39] by web54314.mail.yahoo.com via HTTP; Mon, 12 Mar 2007 12:01:45 PDT Date: Mon, 12 Mar 2007 12:01:45 -0700 (PDT) From: chester c young Subject: how to use a date range in a join To: sql pgsql MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <208535.83136.qm@web54314.mail.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/143 X-Sequence-Number: 27781 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