>But I haven't of JOIN. I think that I can do something like:
>INNER JOIN thetable b ON b.date = (select min(date) ... where c.date > a.date )
>
>Can this be good?

this might be you're only option but I think you want a MAX() and not MIN(). You want the maximum date that is less than the date in the outer query.

-Mike