Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'
;
WHERE ProductNo NOT IN ( '01', '52')
WHERE ProductNo NOT IN ( '01', '52')
LOAD.......;
SQL SELECT
CategoryID,
ProductNo,
ProductName
FROM 'Finished Products Table'
WHERE ProductNo <> '01'
AND ProductNo <> '52';
Thank you both! Could have done it either way.