Simple example that shows how to fix the following error:

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, , = , = or when the subquery is used as an expression.

More info: http://howtodomssqlcsharpexcelaccess.blogspot.ca/2015/05/ms-sql-how-to-fix-error-subquery.html