Received: from hotmail.com (oe67.pav2.hotmail.com [64.4.36.201]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0F6e9V68111 for ; Tue, 15 Jan 2002 01:40:09 -0500 (EST) (envelope-from limspirit@hotmail.com) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Mon, 14 Jan 2002 22:40:09 -0800 X-Originating-IP: [202.188.31.226] From: "KH Lim" To: Subject: Problem with the postgresql operator. Date: Tue, 15 Jan 2002 14:39:54 +0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0005_01C19DD2.7F034BE0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Message-ID: X-OriginalArrivalTime: 15 Jan 2002 06:40:09.0560 (UTC) FILETIME=[79FD1D80:01C19D8F] X-Archive-Number: 200201/161 X-Sequence-Number: 6247 This is a multi-part message in MIME format. ------=_NextPart_000_0005_01C19DD2.7F034BE0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 ------=_NextPart_000_0005_01C19DD2.7F034BE0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Dear All,
 
    What is the correct ope= rator for=20 not equal to in select statement? I'm a bit=20 confuse.
 
Situation
 
Let say I want to select stock_key from st= ock_lot=20 with the condition stock_lot's lot_no is not equal to=20 stocks' lot_no. What select statement should I use?
 
Thank you in advance
 
Lim
------=_NextPart_000_0005_01C19DD2.7F034BE0--