Problem with the postgresql operator.

Dear All,

 

    What is the correct operator for not equal to in select statement? I'm a bit confuse.

 

 

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