Received: from sowrong.org (syr-24-24-23-149.twcny.rr.com [24.24.23.149]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f2D3nKx34813 for ; Mon, 12 Mar 2001 22:49:20 -0500 (EST) (envelope-from cjc26@sowrong.org) Received: (from cjc26@localhost) by sowrong.org (8.11.0/8.11.0) id f2D3nCB17528; Mon, 12 Mar 2001 22:49:12 -0500 (EST) Date: Mon, 12 Mar 2001 22:49:12 -0500 From: Cliff Crawford To: Alder Cc: pgsql-sql@postgresql.org Subject: Re: SQL Dummy Needs Help Message-ID: <20010312224912.A17508@cornell.edu> References: <3aa9287b@obsidian.gov.bc.ca> <20010312211421.A17214@cornell.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <20010312211421.A17214@cornell.edu>; from cjc26@cornell.edu on Mon, Mar 12, 2001 at 09:14:21PM -0500 X-Archive-Number: 200103/246 X-Sequence-Number: 1905 * Cliff Crawford menulis: > > SELECT table2.title_no, table2.paidto_date > FROM table1, table2 > WHERE table1.title_no=table2.title_no > AND (date_part('month', table1.effect_date) != > date_part('month', table2.paidto_date) > OR date_part('day', table1.effect_date) != > date_part('day', table2.paidto_date)); Ooops, I keep confusing C and SQL operators...the "!=" above should be "<>". -- Cliff Crawford He who sacrifices his conscience to ambition burns a picture to obtain the ashes. - Chinese proverb