SELECT * FROM act x inner join act_date y on x.no=y.a_no where a_date > CURDATE() order by a_date asc