select Id As [序号],MachNo As [机器号],CardNO As [内部卡号],CardType As [车类型],InTime As [进场时间],OutTime As [出场时间],FreeType As [优惠类型],FreeNumber As [优惠金额],CreateTime As [扫码时间],IsAccount As [收费金额],AccountDate As [建库时间],CarNo As [车牌号],CustomerID As [商家代码],DisCountID As [记录流水号],b.TicketNo As [优惠券号] from (select TicketNo ,max([_Identify]) as dd from {FreeLog} Where customerID='00059' Order By createtime) as a inner join {FreeLog} as b on a.[_Identify]=b.[_Identify] Where b.customerID='00059' Order By b.createtime