[RESOLVED] How to sort the records?

How to sort the record? I want to sort this two field name "pemilik.Pemilik1"and "[Prestasi hasil].Plot" field name . I relate three tables using "Plot" field name. My tables name is "[Prestasi hasil]","tanah", and "pemilik"

Quote:

---

.Open "SELECT pemilik.Pemilik1,pemilik.Pemilik2,[Prestasi hasil].Plot FROM [Prestasi hasil],pemilik,tanah where [Prestasi hasil].Plot=pemilik.Plot and [Prestasi hasil].Plot=tanah.PLOT"

---

Do a GROUP BY on these fields.

What difference between Group by and Order by?

Actually there is a difference and I should have said ORDER BY (which is actually what I meant)