select lastname,sex,age from table1 union all select lastname1 as lastname,sex1 as sex,age1 as age from table2