↓こんな感じ 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, …