this is the code of a access datasource qury used in a asp.net+vb code web.
SELECT PersData.PNO, PersData.RANK, PersData.Name, PersData.DOC, PersData.DOSEN, PersData.Batch, PersData.CourseStr, Milqual.PNO AS Expr1, Milqual.QUALIFICATION
FROM (PersData INNER JOIN Milqual ON PersData.PNO = Milqual.PNO)
ORDER BY PersData.DOC, PersData.Batch"
i want to add GROUP BY PNO function in above query how is it possible