java我需要对联接表的列进行排序

Question

我有多对多关系表，我有这样的查询

SELECT DISTINCT vp.quotes 
from VehiclePlan as vp 
LEFT JOIN vp.quotes q 
LEFT JOIN q.customer c 
WHERE (1=1) AND vp.date=(:date) AND vp.vehicleId=(:vehicleId)  
ORDER BY q.collectionDateTime

但我的数据仍然不是有序的。请帮我解决这个问题