Using multiple values ​​in a SQL query, where the condition

Question

Select Distinct SomeDay.SomeDayID, SomeDay.FolderName, SomeDay.FolderColor from SomeDay, SomeDayEvent where SomeDay.SomeDayID != 4,3,2,1; 

Answer 1

You cannot use != For multiple values ​​for which you should use not in , for example:

 Select Distinct SomeDay.SomeDayID,SomeDay.FolderName,SomeDay.FolderColor from SomeDay,SomeDayEvent where SomeDay.SomeDayID not in (4,3,2,1); 

Answer 2

You cannot separate values ​​in the WHERE part by comma. You must use the keyword IN or BETWEEN.

 SomeDay.SomeDayID NOT IN (1,2,3,4) 

or

 SomeDay.SomeDayID NOT BETWEEN 1 AND 4 

Answer 3

Select Distinct SomeDay.SomeDayID,SomeDay.FolderName,SomeDay.FolderColor from SomeDay,SomeDayEvent where SomeDay.SomeDayID NOT IN (4, 3, 2, 1)

Use the IN clause.

Answer 4

Is SomeDayID valid? You should know that expression

 NULL NOT IN (1, 2, 3, 4) 

does not evaluate to TRUE.