This query is the subquery. It returns more than one row. When you put it inside parenthesis and named it as a column with the
keyword, you designated it as a subquery.
(select L.lineName from tblLine L inner join TERMSHR..tblCompany C on L.CompanyCode=C.CompanyCode where L.Location='Mirpur') As LineName
Without seeing the DDL for the tables and understanding the output requirements, it is difficult to advise you on a solution.