mysql full join

create table tab11(id int,`name` varchar(3));
create table tab22 (id int,`name` varchar(3));
insert into tab11 values
(1,'tt1'),
(2,'tt2'),
(4,'tt4');
insert into tab22 values
(3,'tt3'),
(5,'tt5'),
(6,'tt6');

select * from (
select id,`name`,'' as name2 from tab11
union all
select id,'' as `name`,`name` as name2 from tab22
) T  order by id;

 

query result(6 records) 
id name name2 
1 tt1  
2 tt2  
3  tt3 
4 tt4  
5  tt5 
6  tt6