SQL IN

The SQL IN operator is used to search from a list of values in an SQL WHERE clause. The list could be the result of an SQL SELECT query.

SQL IN Operator Syntax

SELECT ColumnName1, ColumnName2, ColumnName3, ...
FROM TableName
WHERE ColumnName IN (Value1, Value2, Value3, ...)

Or:

SELECT ColumnName1, ColumnName2, ColumnName3, ...
FROM TableName1
WHERE ColumnName IN
          (
               SELECT ColumnName 
               FROM TableName2 
               WHERE prediction
          )

SQL IN Operator Example

Table: Employees

Example 1
Select employees whose first name is Mazojys, Jssme or Tyoysww:

SELECT *
FROM Employees
WHERE FirstName IN ('Mazojys', 'Jssme', 'Tyoysww')

The result will look like:

Example 2
We have another table EmpProject identifies the employees which projects they involved in.
Table: EmpProject

We want to select employees who take part in the project 0032:

SELECT *
FROM Employees
WHERE EmployeeId IN 
          (
               SELECT EmployeeId
               FROM EmpProject 
               WHERE ProjectId = '0032'
          )

The result will look like: