select
  <do sth useful here>
from 
table a
inner join
table b
on
a.date<b.date
inner join
table c
on b.date<c.date