I have a standard Query and in the query I want to filter out using an IN statement with two rules...I attempted to google this to no avail and it's the first time I have needed to do this. I want to filter out any results where the 'Id' and 'Amount' fields equal the same fields in the main query. If there is a better way I am up for learning as I just started SQL this year. ...Normally I would so something like
WHERE
(Table1.Id NOT IN (
SELECT Table2.Id
FROM Table2
WHERE
(Rules here)
)