Re: join table with itself?

SELECT  present.day, present.low, (MIN(future.day)-present.day) as

days2fall FROM history AS present JOIN history AS future ON ( present.day < future.day AND
     future.low <= present.low )
GROUP BY present.day,present.low
ORDER BY days2fall DESC