mysql建视图
0
[待解决问题]
代码如下：
CREATE VIEW v_order
AS
(
select totalPrice,totalCommssion,roomsNumber,checkinDate,checkoutDate,hotelEn,paymentType,orderState from g_order_third_info
union all
select totalPrice,totalCommssion,roomsNumber,checkinDate,checkoutDate,hotelEn,paymentType,orderState from h_order_query
union all
select total_price,total_commssion,rooms_number,checkin_date,checkout_date,hotel_en,payment_type,ur_cancel_status from h_order_ur
);
