help in correcting the syntax error of the below create table with as with multiple select
You can get the result by using UNION ALL .
Take help of following example for understanding:

create table empnew as select * from employees union all select * from employees;


As @a_horse_with_no_name perfectly mentioned !