The error message is pretty explicit:
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
What it is saying is that you can't do this:
SELECT A, (SELECT B FROM BTable) FROM ATable
Unless the
BTable
SELECT query returns one single value at all times.
An that's for good reason: if the
ATable
query returns one value, and the
BTable
query returns two, SQL has no idea what to display inteh single row!
Almost certainly, instead of a sub query and a long list of tables to select from:
SELECT ... FROM Application_Status a,MST_Service b,MST_ServiceType c,KSEEBMASTERS.dbo.MST_SCHOOL s ,MST_Division d
where ...
You need to think about your data relationships rather more carefully, and use JOINs to fetch related data:
SQL Joins[
^]