Using multiple values in SQL query where clause

Select Distinct
  SomeDay.SomeDayID, SomeDay.FolderName, SomeDay.FolderC开发者_运维知识库olor
from
  SomeDay, SomeDayEvent
where
  SomeDay.SomeDayID != 4,3,2,1;

You can not use != for multiple values for that you should use not in like:

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

You can't separate values in the WHERE part by comma. You have to use the IN or BETWEEN keyword.

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

or

SomeDay.SomeDayID NOT BETWEEN 1 AND 4

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

Use the IN clause.

Is SomeDayID nullable? You should be aware that the expression

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

does not evaluate to TRUE.