error in select query

Question

I am getting an error: plz help me........

Incorrect syntax near the keyword 'select'.

the bold select in the query gets error

select * from (SELECT Ci.iInstNumber AS InstNo,ci.dInstDate AS InstDate, Ci.fInstAmount AS InstAmount
FROM tblChitInstalments ci
WHERE Ci.dInstDate <=@TrDate
select isnull(sum(fAmount),0) as TotalPaid from tblChitReceipts where iRegId=@iRegId and cType='D'

Sandeep Singh Shekhawat · Answer

1. select * from (SELECT Ci.iInstNumber AS InstNoci.dInstDate AS InstDate Ci.fInstAmount AS InstAmount FROM tblChitInstalments ci WHERE Ci.dInstDate ) ---you are missing this 2. select isnull(sum(fAmount)0) as TotalPaid from tblChitReceipts where iRegId=@iRegId and cType='D' Thanks Sandeep

Santhosh Kumar Jayaraman · Answer

Can you be more clear? do you have 2 select queries here? 1. SELECT Ci.iInstNumber AS InstNoci.dInstDate AS InstDate Ci.fInstAmount AS InstAmount FROM tblChitInstalments ci WHERE Ci.dInstDate 2. select isnull(sum(fAmount)0) as TotalPaid from tblChitReceipts where iRegId=@iRegId and cType='D'