mysql多表创建视图

CREATE VIEW v_order AS SELECT id,order_num,makecard_id,user_id,payable_money,reduce_money,real_money,pay_type,state,operate_id,create_time,1 as place FROM jy_ct_order
                UNION ALL SELECT id,order_num,makecard_id,user_id,payable_money,reduce_money,real_money,pay_type,status as state,operate_id,create_time,2 as place FROM jy_tyg_order
                UNION ALL SELECT id,out_trade_no as order_num,makecard_end_id as makecard_id,user_id,payable_amount as payable_money,publish_amount as reduce_money,real_amount as real_money,'card' as pay_type,status as state,operate_id,clear_time as create_time,3 as place FROM jy_qlx_order
                UNION ALL SELECT id,out_trade_no as order_num,makecard_id,user_id,payable_amount as payable_money,publish_amount as reduce_money,real_amount as real_money,pay_type,pay_status as state,operate_id,pay_time,4 as place FROM jy_school_order