How to collect and sort data from 3 tables?

hi,

don't use brackets in the from clause like you do;

SELECT 
        BrandName, 
        ModelName, 
        S.AvrPrice 
FROM 
                Statistic AS S 
                JOIN Brands AS B ON B.BrandIndex=S.BrandIndex 
                JOIN Models AS M ON M.ModelIndex=S.ModelIndex
ORDER BY 
        BrandName, 
        ModelName

---

Regards, Nico



pdfaid, my blog