Hello all,
I have select query which is giving me error
Please consider Text marked in bold which is causing this error.
select ROW_NUMBER() OVER (ORDER BY um.Id) AS [Sr_No],um.DOCRcvdDt as InwardDate, um.ScanId,um.ProposerName as CustomerName,um.RiskStartDt,um.RiskEndDt,um.IntermediaryCode,um.ECNNumber,um.ProposalAmount,Convert(varchar(20),um.DOCRcvdDt)+' '+um.DOCRcvdTime as DOCRcvdDtTime,um.Remarks,bb.BBName as Branch,i.NAME,
it.[Description] as PaymentMode,r.InstrumentNumber,r.InstrumentDate,r.Amount as InstrumentAmount,a1.dtTime QC1PickedDtTime,ld1.Username as QC1UserId,a2.dtTime QC1DoneDtTime,
a3.dtTime DEPickedDtTime,a4.dtTime DEDoneDtTime,a5.dtTime QC2PickedDtTime,a6.dtTime QC2DoneDtTime,ld2.Username as DEUserId,ld3.Username as QC2UserId,
a7.dtTime as PolicyIssuedDtTime,sm.ContactId,sm.ProposalNo,sm.PolicyNo,sm.ReceiptNo,ld4.Username as ScanUserId,count(dm.Id)
from UploadMaster um
left Join LoginData ld on um.EmpId=ld.Id
left Join BBMaster bb on ld.BBId=bb.Id
left Join IMD i on i.[IMD code]=um.IntermediaryCode
left Join T_Instrument_Type it on it.ID=um.PaymentMode
left Join Receipt r on r.TxnId=um.ScanId
left Join Aging a1 on a1.UpldMstrId=um.Id and a1.Status='QC1 Picked'
left Join LoginData ld1 on ld1.Id=a1.UpdatedBy
left Join Aging a2 on a2.UpldMstrId=um.Id and a2.Status='QC1 Accepted'
left Join Aging a3 on a3.UpldMstrId=um.Id and a3.Status='DE Picked'
left Join LoginData ld2 on ld2.Id=a3.UpdatedBy
left Join Aging a4 on a4.UpldMstrId=um.Id and a4.Status='DE Accepted'
left Join Aging a5 on a5.UpldMstrId=um.Id and a5.Status='QC2 Picked'
left Join LoginData ld3 on ld3.Id=a5.UpdatedBy
left Join Aging a6 on a6.UpldMstrId=um.Id and a6.Status='QC2 Accepted'
left Join Aging a7 on a7.Status='Policy Issued' and a7.UpldMstrId=um.Id
left Join StatusMaster sm on sm.TransactionId=um.ScanId
left Join LoginData ld4 on ld4.Id=um.EmpId
left Join DiscrepencyMaster dm on dm.UploadId=um.Id
group by dm.Id
order by um.ScanId
Error :
Column 'UploadMaster.Id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Please explain why this error is coming.
And how to sort it.
Thanks
Regards
SUNIL MALI.