fxnZEBPk

1SELECT * FROM main
2UNION
3SELECT * FROM other
4	
5CREATE EXTERNAL TABLE IF NOT EXISTS `test.union`(
6  SELECT * FROM main
7  UNION
8  SELECT * FROM other)