cgQuery = "select a.StudentName,d.AdmissionNo,b.ClassName,c.CurrentSection from StuAdmission as a,StuMasterClass as b,StuSectionDetails as c,HostelAdmissionDetails as d,StuClassMapping as e where d.AdmissionNo=a.AdmissionNo and d.ClassID=b.ClassID and e.ClassMappingID=c.ClassMappingID and e.ClassID=d.ClassID and a.CompanyID=d.CompanyID and b.CompanyID=c.CompanyID and d.CompanyID=e.CompanyID and StudentPresentStatus<>'L' " Sir,In this Query I want to take the distinct (StudentName,AdmissionNo,ClassName) thankyou, (D.chandramohan)
Tags: