I currently want everything that is not 'Apple' or 'Banana' under column 'Fruits'.
My current code is:
SELECT *
FROM [MyTable]
WHERE [MyTable].[Fruits] <> "Apple" OR [MyTable].[Fruits]<>'Banana'
;
Yet it still gives me Banana and Apple values. Any advice?