SELECT * FROM act x inner join act_date y on x.a_no=y.a_no where y.no=243