Today I want to discuss one thing about IN clause in SQL Server.
SELECT * from
(ID, Name) in (
select CustomerID, CustomerName from tblCustomerOrders
In the above statement, we wanted to list the details of customers who have submitted some orders. When you run this statement in SQL Server (with the tables tblCustomer and tblCustomerOrders already created), an error is generated about this. The real reason is that SQL Server does not support more than one parameters in the IN clause.