is not
Hello
I've got this sql statement:
select * from products p, productsubcategories ps, productcategories pc
where p.deleted = 0 and ps.subcategoryid = p.subcategoryid
and pc.categoryid = ps.categoryid and ps.subcategoryid is not '136'.
Not sure what the syntax should be for 'is not' at the end of the statement; basically I want to select everything except that with a subcatid of 136?
Many thanks
Adam
|
