Subquery within another subquery is called Nested Subquery. If the output of a subquery depends on column values of the parent query table then the query is called Correlated Subquery.
SELECT adminid(SELEC Firstname+' '+Lastname FROM Employee WHERE
empid=emp. adminid)AS EmpAdminId FROM Employee;
The result of the query is the details of an employee from the Employee table.
