仅返回最大值小于指定值的行

仅返回最大值小于指定值的行

您想将条件从联接拉到

having

子句中。联接 仅 查看那些日期之前的记录，因此您不知道之后是否发生任何事情。

SELECt *FROM tbldealermobiles  INNER JOIN tblhistory ON tbldealermobiles.FCS = tblhistory.FCS  INNER JOIN tblAllDealers ON tbldealermobiles.FCS = tblAllDealers.FCSWHERe tblAllDealers.CustGroup in ('Virtual', 'Outbound')GROUP BY tbldealermobiles.mobilenumber HAVINg MAX(tblhistory.PurchaseDate) < MAX(case when tblAllDealers.CustGroup = 'Virtual' then date('2013-03-22')          when tblAllDealers.CustGroup = 'Outbound' then date('2013-04-21')     end)ORDER BY tblhistory.PurchaseDate DESC