drop table if exists z_a10_a11;

create table z_a10_a11
select 1 as typ, 
       p01 as p01, 
       p00 as p00, 
       p02 as p02, 
       p02_1 as p02_1, 
       p401 as p401, 
       p04 as p04, 
       p05 as p05
FROM a10
       
union all

select 2 as typ, 
       p01 as p01, 
       p00 as p00, 
       p02 as p02, 
       p02_1 as p02_1, 
       p401 as p401, 
       p04 as p04, 
       p05 as p05
FROM a11

union all

select 3 as typ, 
       p01 as p01, 
       p00 as p00, 
       p02 as p02, 
       p02_1 as p02_1, 
       p401 as p401, 
       p04 as p04, 
       p05 as p05
FROM a30;