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