**Subquery returned more than 1 value. This is not permitted when the **subquery follows =, !=, <, <= , >, >= or when the subquery is used as an **expression." lcSql="select a.batchno,(select sum(b.price) from detail b ) as total, (select sum(c.taxamount) from taxes c group by c.batchno ) as Taxes, ((select sum(b.price) from detail b)+(select sum(c.taxamount) from taxes c)) as grandtotal from header a inner join detail b on a.batchno = b.batchno "Please assist to fix my query.