Received: from primus.vsservices.com (primus.vsservices.com [63.66.136.75]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0FFuOV89406 for ; Tue, 15 Jan 2002 10:56:24 -0500 (EST) (envelope-from gclarkii@vsservices.com) Received: from prime.vsservices.com (conr-adsl-dhcp-26-38.txucom.net [209.34.26.38]) by primus.vsservices.com (8.11.3/8.11.3) with SMTP id g0FFuRB67729; Tue, 15 Jan 2002 07:56:27 -0800 (PST) (envelope-from gclarkii@vsservices.com) Date: Tue, 15 Jan 2002 09:56:29 -0600 From: GB Clark To: "KH Lim" Cc: pgsql-sql@postgresql.org Subject: Re: Problem with the postgresql operator. Message-Id: <20020115095629.56e49d68.gclarkii@vsservices.com> In-Reply-To: References: X-Mailer: Sylpheed version 0.6.6 (GTK+ 1.2.10; i386-unknown-freebsd4.4) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Archive-Number: 200201/224 X-Sequence-Number: 6308 On Tue, 15 Jan 2002 14:39:54 +0800 "KH Lim" wrote: > Dear All, > > What is the correct operator for not equal to in select statement? I'm a bit confuse. > > Situation > > Let say I want to select stock_key from stock_lot with the condition stock_lot's lot_no is not equal to stocks' lot_no. What select statement should I use? > > Thank you in advance > > Lim > Just use the standard SQL... <> Works just fine and it is in the books. GB -- GB Clark II | Roaming FreeBSD Admin gclarkii@VSServices.COM | General Geek CTHULU for President - Why choose the lesser of two evils?