Re: Problem with the postgresql operator.

On Tue, 2002-01-15 at 06:39, 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? 

The operator is !=

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
    "For I know that my redeemer liveth, and that he shall      stand at the latter day upon the earth"
                                 Job 19:25