Loading

error in select query

anil john

14y1.3k

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'

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sandeep Singh Shekhawat14y ago
1.
select * from (SELECT Ci.iInstNumber AS InstNo,ci.dInstDate AS InstDate, Ci.fInstAmount AS InstAmount
FROM tblChitInstalments ci
WHERE Ci.dInstDate <=@TrDate) ---you are missing this

2.
select isnull(sum(fAmount),0) as TotalPaid from tblChitReceipts where iRegId=@iRegId and cType='D'

Thanks
Sandeep
0
Santhosh Kumar Jayaraman14y ago
Can you be more clear?

do you have 2 select queries here?

1.SELECT Ci.iInstNumber AS InstNo,ci.dInstDate AS InstDate, Ci.fInstAmount AS InstAmount
FROM tblChitInstalments ci
WHERE Ci.dInstDate <=@TrDate

2. select isnull(sum(fAmount),0) as TotalPaid from tblChitReceipts where iRegId=@iRegId and cType='D'
0