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?