--直接执行下面的语句不出错:
select WORD1 AS `BILL_CODE`, WORD3 AS `ZONE`, WORD2 AS `DATE` from `T_IMAGE`
union all
select BILL_CODE AS `BILL_CODE`,ZONE AS `ZONE`,SEND_DATE AS `DATE` from `T_BILL`
--但是到视图里面确报错了:
CREATE OR REPLACE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `V_BILL` AS
(
(select WORD1 AS `BILL_CODE`, WORD3 AS `ZONE`, WORD2 AS `DATE` from `T_IMAGE`) union all (select BILL_CODE AS `BILL_CODE`,ZONE AS `ZONE`,SEND_DATE AS `DATE` from `T_BILL`)
)
--麻烦指点, 谢谢!
AS
SELECT WORD1 AS `BILL_CODE`, WORD3 AS `ZONE`, WORD2 AS `DATE` FROM `T_IMAGE`
UNION ALL
SELECT BILL_CODE AS `BILL_CODE`,ZONE AS `ZONE`,SEND_DATE AS `DATE` FROM `T_BILL`;
(select WORD1 AS `BILL_CODE`, WORD3 AS `ZONE`, WORD2 AS `DATE` from `T_IMAGE`) union all (select BILL_CODE AS `BILL_CODE`,ZONE AS `ZONE`,SEND_DATE AS `DATE` from `T_BILL`)
-> (select WORD1 AS `BILL_CODE`, WORD3 AS `ZONE`, WORD2 AS `DATE` from `T_IM
AGE`) union all (select BILL_CODE AS `BILL_CODE`,ZONE AS `ZONE`,SEND_DATE AS `DA
TE` from `T_BILL`)
-> ;
Query OK, 0 rows affected (0.05 sec)mysql>