首页 新闻 赞助 找找看

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
);

问题补充:

我想请问一下,为什么总是报错!!

灬李某某灬的主页 灬李某某灬 | 菜鸟二级 | 园豆:202
提问于:2016-10-19 15:31
< >
分享
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册