SELECT a.voyageNum,CONCAT(a.startDate,'~',a.endDate) AS 日期 FROM tchw_voyageoilcost a ,tchw_voyageoilcostinfo b WHERE a.isDeleted=0 AND a.id=b.voyageOilCostId AND a.shipId=3 AND a.belongMonth='2013-09' ORDER BY a.voyageNum
SELECT a.voyageNum,CONCAT(a.startDate,'~',a.endDate) AS 日期 FROM tchw_voyageoilcost a ,tchw_voyageoilcostinfo b WHERE a.isDeleted=0 AND a.id=b.voyageOilCostId AND a.shipId=3 AND a.belongMonth='2013-09' ORDER BY a.voyageNum