Database Query Execution Error

There was an error with the following statement...

SELECT tblUsedStockME_new.Stock, tblUsedStockME_new.Make, tblUsedStockME_new.Model, tblUsedStockME_new.Desc1, tblUsedStockME_new.Price, tblHoursME.Location, tblUsedStockME_new.ModelYear, tblUsedStockME_new.Location FROM tblUsedStockME_new LEFT OUTER JOIN tblHoursME ON tblUsedStockME_new.Location = tblHoursME.LocCode LEFT OUTER JOIN tblUsedSubCatME_new ON tblUsedStockME_new.CatCode = tblUsedSubCatME_new.Code WHERE tblUsedSubCatME_new.CatID = '2' ORDER BY tblUsedStockME.Model ASC

The error message generated was...

[MySQL][ODBC 3.51 Driver][mysqld-5.0.51a-community-nt]Unknown column 'tblUsedStockME.Model' in 'order clause'