mysql?で複数のテーブルを縦?に結合(union)し、create view

↓こんな感じ

create view h_delivery_to
 as    select * from h_delivery_to_org
union  select * from h_delivery_to_int;

または、カラムを指定して

create view h_tanka_tmp
as     select ht.* from h_tanka ht
union  select '-' as hansha, '-' as hansha_sub, ot.* from org_tanka ot;