LOAD/SELECT, skip specific records

[#1]

I have two product numbers (01 and 52) that I would like to skip when loading my table.  I get a syntax error and can't get this to work any other way.  Can anyone tell what the syntax should be, whether the exclusion takes place in the SELECT or the LOAD statement, also.  Thank you so much.

My code looks like this:

LOAD.......;

SQL SELECT

  CategoryID,

  ProductNo,

  ProductName

FROM     'Finished Products Table'

  WHERE ProductNo NOT '01' AND    

               ProductNo NOT '52'

;

[Anonymous · Accepted solution]

WHERE ProductNo NOT IN ( '01', '52')

[#3]

LOAD.......;

SQL SELECT

  CategoryID,

  ProductNo,

  ProductName

FROM     'Finished Products Table'

  WHERE ProductNo <> '01'

  AND ProductNo <> '52';

[#4]

Thank you both!  Could have done it either way.