帮忙优化一条SQL语句,谢谢
select distinct SaleWholesalerID,SaleFileNo,SaleContract,SaleDate,Sale.other from ((Sale left join Wholesaler on Sale.SaleWholesalerID=Wholesaler.WholesalerID) left join Product on Sale.SaleProductID=Product.ProductID) where PayDate>=#"&StartDate&"# and PayDate<=#"&EndDate&"# order by SaleDate desc,SaleFileNo desc
数据库ACCESS
各位高手.帮忙看一下