PDA

View Full Version : need help with in and not in


o0O0o.o0O0o
07-16-2008, 06:02 AM
i have this query , but it is giving error

UPDATE tblzeromovement SET testActive =1
WHERE plu IN ( 8000070014435, 8000070014558, 8000070014602 )
AND NOT IN ( 8000070014435 )


i have 4-5 products code , i have keep one product and make others non active based on calculation . Is this the right method

abduraooft
07-16-2008, 09:04 AM
AND NOT IN ( 8000070014435 ) I think that should be
AND plu NOT IN ( 8000070014435 )