SELECT <column-list> FROM <table-list> WHERE <field> IN <criteria1, criteria2, criteria3,...>

The IN operator test whether a field value matches any value in a subquery or a list.

Table: Orders

OrderID	Customer	Employee	Order Date	ShippedVia	Freight	ShipCountry
10248	Wilman Kala	Buchanan, Steven	04-07-1996	Federal Shipping	32.38	France
10249	Hanari Carnes	Peacock, Margaret	08-07-1996	United Package	65.83	Brazil
10250	Hanari Carnes	Leverling, Janet	08-Jul-1996	United Package	58.17	Brazil
10251	Chop-suey Chinese	Buchanan, Steven	11-Jul-1996	United Package	22.98	Switzerland
10252	Richter Supermarkt	Dodsworth, Anne	12-Jul-1996	Federal Express	148.33	Switzerland

SELECT Customer, Employee FROM Orders WHERE ShipCountry IN ('Brazil', 'Switwerland')

The above SQL statement returns orders from Brazil and Switzerland as shown in Resultset1 below.

Resultset1

OrderID	Customer	Employee	Order Date	ShippedVia	Freight	ShipCountry
10249	Hanari Carnes	Peacock, Margaret	08-07-1996	United Package	65.83	Brazil
10250	Hanari Carnes	Leverling, Janet	08-Jul-1996	United Package	58.17	Brazil
10251	Chop-suey Chinese	Buchanan, Steven	11-Jul-1996	United Package	22.98	Switzerland
10252	Richter Supermarkt	Dodsworth, Anne	12-Jul-1996	Federal Shipping	148.33	Switzerland

If you want to return orders from all countries except Brazil or Switzerland, you can use NOT IN instead. The following command will return order 10248 from Orders table because this order is not from Brazil or Switzerland.

SELECT Customer, Employee FROM Orders WHERE ShipCountry NOT IN ('Brazil', 'Switwerland')

Resultset2

OrderID	Customer	Employee	Order Date	ShippedVia	Freight	ShipCountry
10248	Wilman Kala	Buchanan, Steven	04-07-1996	Federal Shipping	32.38	France