Re: Problem with the postgresql operator. - Mailing list pgsql-sql

On Tue, 15 Jan 2002 14:39:54 +0800
"KH Lim" <limspirit@hotmail.com> 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?