Can I negate a SQL statement?

Question

I have a particular SQL query now I would like to return the oposite of that query is there a sql statement to do that?

Answer 1

Yup, negate it in the WHERE clause.

Or use a subquery that has all of the records that you don't want, then you can select the records that don't match the subquery.

Example 1:

SELECT whatever FROM MyTable WHERE MyColumn is not null (gets all the records wit the not nulled column instead of the records with the nulled column)

Example 2:

SELECT whatever FROM MyTable WHERE MyPrimaryKey NOT IN
(SELECT MyPrimaryKey FROM MyTable WHERE ....)

Answer 2

Well you could do something like

SELECT * FROM tblStuff WHERE
tblStuff.ID NOT IN (SELECT ID FROM vw_SomeViewWithAQuery)